SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 2069 | 10747431382512 | 5194505184 | 241912409376 | |
wait/io/file/innodb/innodb_data_file | 4606 | 4643452502304 | 1008130992 | 245410425744 | |
wait/io/file/innodb/innodb_temp_file | 578 | 1531639329792 | 2649894984 | 59624750592 | |
wait/lock/metadata/sql/mdl | 7 | 170583121632 | 24369017376 | 38185382928 | |
wait/io/file/sql/binlog | 381 | 146526395664 | 384583584 | 17456186352 | |
wait/io/file/sql/io_cache | 260 | 100782856416 | 387626184 | 64782273600 | |
wait/io/table/sql/handler | 2886 | 62503716528 | 21657504 | 21485978448 | |
wait/io/file/sql/ERRMSG | 60 | 60401724240 | 1006695360 | 28587883632 | |
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 | 598 | 607091760 | 1015080 | 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 |
|