您的位置主页 > MYSQL

max_length_for_sort_data调整

 

 
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!