SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/table/sql/handler | 14858242 | 7587896866176 | 510576 | 11769024432 | |
root | wait/io/file/innodb/innodb_temp_file | 72 | 678002975760 | 9416707872 | 38026740048 | |
root | wait/io/file/innodb/innodb_data_file | 695 | 285579581760 | 410905704 | 56538678768 | |
root | wait/io/file/sql/ERRMSG | 65 | 49511847792 | 761720520 | 10122740496 | |
root | wait/io/file/myisam/kfile | 16 | 9807419424 | 612963648 | 6047176080 | |
root | wait/io/file/csv/metadata | 8 | 6275712960 | 784464120 | 2583691440 | |
root | wait/lock/table/sql/handler | 1714 | 1807197744 | 1054152 | 13425984 | |
root | wait/io/file/sql/binlog | 308 | 1606261536 | 5215056 | 27857280 | |
root | wait/io/file/myisam/dfile | 52 | 1396033584 | 26846688 | 671130768 | |
root | wait/io/file/sql/io_cache | 30 | 992919312 | 33097152 | 544381200 | |
root | wait/io/file/csv/data | 70 | 456769632 | 6525024 | 45840960 | |
root | wait/io/file/sql/binlog_index | 2 | 194826192 | 97413096 | 193444944 | |
root | wait/lock/metadata/sql/mdl | 1 | 5556144 | 5556144 | 5556144 |
|