设为首页 | 加入收藏
您的位置主页 > MYSQL

max_length_for_sort_data调整

2012-02-21 12:26:07

 

 
For slow queries for which filesort is not used, you might try lowering max_length_for_sort_data to a value that is appropriate to trigger a filesort.
 
意思是:在SQL语句没有filesort的情况下,可以调低 max_length_for_sort_data 可以触发filesort!