MySQL max_allowed_pa​​cket 参数有什么问题？

Question

我需要增加 max_allowed_pa​​cket 参数，以适应一些理论上非常大的项目。如果我将此参数设置为 10M，与将其设置为 1M 或 4M 相比，我要付出多少代价(如果有的话)。感谢您的任何输入!托马斯

Answer 1

我找到了这个解释:http://www.astahost.com/info.php/max_allowed_pa​​cket-mysql_t2725.html

It's safe to increase the value of this variable because the extra memory is allocated only when needed. For example, mysqld allocates more memory only when you issue a long query or when mysqld must return a large result row. The small default value of the variable is a precaution to catch incorrect packets between the client and server and also to ensure that you don't run out of memory by using large packets accidentally.

另请注意，我读到您必须更改 mysql 客户端和 mysql 服务器的值。