Detailed analysis of Mysql Slowlog configuration method (text) _mysql

MySQL log system online for some time, the front end in the slowly cut the site to write, proactive DIY set of MySQL monitoring tools.

Divided into slave status, Sync,objec infot,userprivileges,job status, Slowlog.

This time, Slow_log.

MySQL 1.5 starts to support set global globally to change variable settings. Without restarting the service.

can use

Show variables to view variable settings

Open log_output Table Option 5.1 above version support table and file 2 options are used simultaneously, separate such as: Set global log_output= ' Table,file ';

Open Log_slow_query

Set global log_slow_query = on;

With show variables like ' long% ' view long_query_time value defaults to 10 seconds

In this way MySQL will automatically slowlog more than 10 seconds of query statements to the MySQL Library slow_log table.

Work with SSIS and proc to monitor multiple servers daily. Also applies to large-scale MySQL, next write the monitoring point and face problem.

SSIS Flowchart:

Mail Effect Chart: This is the test with Slowlog long_query_time time set to 0