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 | 450 | 1408620408624 | 3130267536 | 641248888368 | |
root | wait/io/file/innodb/innodb_temp_file | 72 | 719833860240 | 9997692408 | 42047802192 | |
root | wait/io/file/sql/binlog | 351 | 403036951152 | 1148253216 | 29294940576 | |
root | wait/io/table/sql/handler | 83333 | 196406869296 | 2356728 | 13634843904 | |
root | wait/io/file/sql/ERRMSG | 45 | 35664330768 | 792540672 | 4021913280 | |
root | wait/io/file/sql/io_cache | 80 | 3962505888 | 49531152 | 1459949568 | |
root | wait/lock/table/sql/handler | 727 | 1145000208 | 1574760 | 25755312 | |
root | wait/io/file/csv/metadata | 4 | 1106817888 | 276704472 | 991195920 | |
root | wait/io/file/sql/misc | 7 | 684645984 | 97806456 | 544911840 | |
root | wait/io/file/csv/data | 2 | 21198144 | 10599072 | 15130368 | |
root | wait/io/file/sql/binlog_index | 2 | 15759744 | 7879872 | 13669920 |
|