mysql> set global slow_query_log = 1;
mysql> set global slow_query_log_file = '/tmp/slowquery.log';
mysql> set global long_query_time = 0; # 0秒にセットすると全queryをロギング
ダンプしたデータを解析
$ mysqldumpslow -s t /tmp/slowquery.log
-sはソートオプション
Created
November 4, 2013 08:58
-
-
Save nikushi/7299916 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment