SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 2028 | 10564904741952 | 5209518864 | 241912409376 | |
wait/io/file/innodb/innodb_data_file | 4567 | 4543229819040 | 994795032 | 245410425744 | |
wait/io/file/innodb/innodb_temp_file | 575 | 1514707827600 | 2634274368 | 59624750592 | |
wait/io/file/sql/io_cache | 260 | 100782856416 | 387626184 | 64782273600 | |
wait/io/file/sql/binlog | 365 | 90801679056 | 248771688 | 15083359104 | |
wait/io/file/sql/ERRMSG | 60 | 60401724240 | 1006695360 | 28587883632 | |
wait/io/table/sql/handler | 2803 | 57891083712 | 20653248 | 21485978448 | |
wait/io/file/sql/binlog_index | 38 | 51779263536 | 1362611976 | 35470844640 | |
wait/io/file/mysys/cnf | 5 | 1469243424 | 293848632 | 1444132800 | |
wait/io/file/sql/casetest | 15 | 1291776288 | 86118384 | 1201424400 | |
wait/io/file/csv/data | 4 | 1270851648 | 317712912 | 693366432 | |
wait/io/file/myisam/kfile | 12 | 679016976 | 56584704 | 237273696 | |
wait/lock/table/sql/handler | 575 | 576931344 | 1003200 | 16124064 | |
wait/io/file/myisam/dfile | 34 | 556337760 | 16362720 | 278545344 | |
wait/io/file/csv/metadata | 8 | 488640240 | 61079832 | 145834128 | |
wait/io/file/mysys/charset | 3 | 229817808 | 76605936 | 207184032 | |
wait/io/file/sql/misc | 5 | 71854992 | 14370840 | 31424976 | |
wait/io/file/sql/pid | 3 | 15370608 | 5123448 | 10822944 |
|