标题: 使用 table_io_waits_summary_by_table 监控性能 [打印本页] 作者: jiawang 时间: 2026-1-4 18:11 标题: 使用 table_io_waits_summary_by_table 监控性能 查看 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;