|
复制 [MySQL(和PHP搭配之最佳组合)d]; enable the slow query log,窍门 default 10 secondslog-slow-queries; log queries taking longer than 5 secondslong_query_time = 5 ;
log queries that dont use indexes even if they take less than long_query_time; MySQL(和PHP搭配之最佳组合) 4.1 and newer onlylog-queries-not-using-indexes 1.2.3.4. |