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 | 410 | 640719769536 | 1562731104 | 33291158736 | |
root | wait/io/file/innodb/innodb_temp_file | 64 | 621004946496 | 9703202256 | 42047802192 | |
root | wait/io/file/sql/binlog | 283 | 290253231312 | 1025629704 | 29294940576 | |
root | wait/io/table/sql/handler | 83070 | 192701531616 | 2319504 | 13634843904 | |
root | wait/io/file/sql/ERRMSG | 35 | 26179560000 | 747987240 | 4021913280 | |
root | wait/io/file/csv/metadata | 4 | 1106817888 | 276704472 | 991195920 | |
root | wait/io/file/sql/misc | 7 | 684645984 | 97806456 | 544911840 | |
root | wait/lock/table/sql/handler | 373 | 572405856 | 1534368 | 13836768 | |
root | wait/io/file/csv/data | 2 | 21198144 | 10599072 | 15130368 | |
root | wait/io/file/sql/binlog_index | 2 | 15759744 | 7879872 | 13669920 |
|