mysql buffer size_mysql中join_buffer_size的建议最大值是多少？

在一般情况下,无法回答您的问题.这实际上取决于您的查询的配置文件.检查手册,了解它们的用途,并且正确地说：

Setting it larger than required globally will slow down most queries that sort. It is best to increase it as a session setting, and only for the sessions that need a larger size. On Linux, there are thresholds of 256KB and 2MB where larger values may significantly slow down memory allocation (…). Experiment to find the best value for your workload.

There is no gain from setting the buffer larger than required to hold each matching row, and all joins allocate at least the minimum size, so use caution in setting this variable to a large value globally. It is better to keep the global setting small and change to a larger setting only in sessions that are doing large joins. Memory allocation time can cause substantial performance drops if the global size is larger than needed by most queries that use it.