Mysql-开启执行sql日志记录

show global variables like '%general_log%';
set global general_log = 'on';

show global variables like '%slow_query_log%';
set global slow_query_log= 'on';

show global variables like '%log_output%';

[mysqld]
general_log = 1
general_log_file = /path/to/your/general-query.log

slow_query_log = 1
slow_query_log_file = /path/to/your/slow-query.log
long_query_time = 2
log_queries_not_using_indexes = 1