memo

memo dayo.

Indexを使わないSlow Queryを出力する


SET GLOBAL slow_query_log = 1;
SET GLOBAL long_query_time = 5;
SET GLOBAL log_queries_not_using_indexes = 1;
SET GLOBAL slow_query_log_file = '/log_file_path/slow.log';