SELECT * FROM `x$waits_by_user_by_latency`
|
user | event | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|---|
root | wait/io/file/innodb/innodb_temp_file | 222 | 2017980358944 | 9090001536 | 59878315200 | |
root | wait/io/table/sql/handler | 1736694 | 1419329870112 | 817080 | 8452891392 | |
root | wait/io/file/innodb/innodb_data_file | 490 | 143248457088 | 292343568 | 6568184832 | |
root | wait/io/file/sql/io_cache | 330 | 99713059248 | 302160672 | 76279711200 | |
root | wait/io/file/sql/ERRMSG | 55 | 62335428144 | 1133371272 | 11828706912 | |
root | wait/io/file/sql/binlog | 1008 | 19624137456 | 19468152 | 13591518864 | |
root | wait/io/file/myisam/dfile | 58 | 5214590832 | 89906520 | 1980225456 | |
root | wait/io/file/csv/metadata | 8 | 1939050432 | 242381304 | 590607600 | |
root | wait/io/file/myisam/kfile | 16 | 1699679520 | 106229904 | 725359008 | |
root | wait/lock/table/sql/handler | 1066 | 1192419360 | 1118568 | 12204720 | |
root | wait/io/file/csv/data | 4 | 637014048 | 159253512 | 500818032 | |
root | wait/io/file/sql/binlog_index | 2 | 3966864 | 1983432 | 2503248 |
|