使用 table_io_waits_summary_by_table 监控性能

jiawang

查看 I/O 等待次数最多的表：
SELECT object_schema, object_name, count
FROM performance_schema.table_io_waits_summary_by_table
ORDER BY count DESC
LIMIT 10;


查看 I/O 等待时间最长的表：
SELECT object_schema, object_name, sum_timer_wait
FROM performance_schema.table_io_waits_summary_by_table
ORDER BY sum_timer_wait DESC
LIMIT 10;


查看读取行数最多的表：
SELECT object_schema, object_name, rows_read
FROM performance_schema.table_io_waits_summary_by_table
ORDER BY rows_read DESC
LIMIT 10;


查看写入行数最多的表：
SELECT object_schema, object_name, rows_inserted + rows_changed + rows_deleted AS total_rows_written
FROM performance_schema.table_io_waits_summary_by_table
ORDER BY total_rows_written DESC
LIMIT 10;