This buffer is created once per join per thread, plus it represents the minimum value. It seems that if MySQL needs more, it will automatically allocate more. In this case, there should be no need to set this setting, and dangerous to set it to a very high value.
References:
http://dev.mysql.com/doc/refman/5.0/en/s
http://www.mysqlperformanceblog.com/2010/0
No comments:
Post a Comment