SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_data_file | 691 | 974718752304 | 1410591336 | 39707563632 | |
root | wait/io/file/sql/binlog | 1833 | 433928035200 | 236730912 | 24401171520 | |
root | wait/io/file/innodb/innodb_temp_file | 34 | 379185785088 | 11152522920 | 35011754448 | |
root | wait/io/file/sql/io_cache | 222 | 68112034848 | 306810768 | 61872143520 | |
root | wait/io/file/sql/ERRMSG | 65 | 45403321920 | 698512584 | 4423606704 | |
root | wait/io/table/sql/handler | 1294 | 44084703696 | 34068408 | 5498014368 | |
root | wait/io/file/myisam/kfile | 12 | 2881956528 | 240162912 | 1522345968 | |
root | wait/io/file/csv/metadata | 8 | 2753659920 | 344207424 | 1953453216 | |
root | wait/lock/table/sql/handler | 1111 | 1470092976 | 1323168 | 78286560 | |
root | wait/io/file/sql/misc | 10 | 489313440 | 48931344 | 351564048 | |
root | wait/io/file/myisam/dfile | 34 | 440956032 | 12969264 | 388572096 | |
root | wait/io/file/csv/data | 7 | 425581200 | 60797088 | 371827632 | |
root | wait/io/file/sql/binlog_index | 2 | 264975216 | 132487608 | 263430288 |
|