SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 7415 | 35447400701328 | 4780499064 | 703004902512 | |
wait/io/file/innodb/innodb_data_file | 11633 | 10470213793248 | 900044112 | 220595275296 | |
wait/io/file/innodb/innodb_temp_file | 949 | 1096907726112 | 1155856152 | 29537953632 | |
wait/io/file/sql/binlog | 575 | 753180718752 | 1309879296 | 27799900128 | |
wait/io/table/sql/handler | 262604 | 401909321088 | 1530408 | 4244230848 | |
wait/io/file/sql/io_cache | 1194 | 212408568240 | 177896400 | 75009199584 | |
wait/io/file/sql/binlog_index | 38 | 51268642656 | 1349174640 | 26931266208 | |
wait/io/file/sql/ERRMSG | 55 | 19043503776 | 346245504 | 1724734704 | |
wait/lock/table/sql/handler | 6061 | 6661432272 | 1099032 | 89943216 | |
wait/io/file/mysys/cnf | 5 | 1885378176 | 377075424 | 1844532096 | |
wait/io/file/myisam/kfile | 4 | 1412462304 | 353115576 | 1391603664 | |
wait/io/file/sql/casetest | 15 | 1329877296 | 88658328 | 1246562064 | |
wait/io/file/sql/misc | 12 | 1098118032 | 91509792 | 591070128 | |
wait/io/file/csv/metadata | 8 | 967668768 | 120958464 | 540387936 | |
wait/io/file/mysys/charset | 3 | 291233712 | 97077816 | 270161760 | |
wait/io/file/csv/data | 4 | 33025872 | 8256336 | 10959168 | |
wait/io/file/sql/pid | 3 | 22266288 | 7422096 | 14116608 | |
wait/io/file/myisam/dfile | 2 | 13738560 | 6869280 | 12706320 |
|