MySQL 性能分析

1
2
3
4

show status like 'Queries';
show status like 'Threads_connected';
show status like 'Threads_running';
show status like 'Connection_errors_max_connections';

1

show processlist

1
2
3
4

slow_query_log = 1
slow_query_log_file=/var/lib/mysql/slow-query.log
long_query_time = 1
log_queries_not_using_indexes = 1

1

systemctl restart mysqld

1
2

show variables like 'slow_query%';
show variables like 'long_query_time';