SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 9175 | 43747427551344 | 4768111920 | 703004902512 | |
wait/io/file/innodb/innodb_data_file | 14051 | 12624103046016 | 898448496 | 220595275296 | |
wait/io/file/innodb/innodb_temp_file | 1092 | 1340481569328 | 1227547200 | 29537953632 | |
wait/io/file/sql/binlog | 731 | 825299929344 | 1129001016 | 27799900128 | |
wait/io/table/sql/handler | 272327 | 423984469392 | 1556808 | 4597475520 | |
wait/io/file/sql/io_cache | 1560 | 298107791520 | 191094552 | 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 | 7366 | 8145722640 | 1105632 | 89943216 | |
wait/io/file/mysys/cnf | 5 | 1885378176 | 377075424 | 1844532096 | |
wait/io/file/myisam/kfile | 4 | 1412462304 | 353115576 | 1391603664 | |
wait/io/file/sql/misc | 14 | 1339162704 | 95654328 | 591070128 | |
wait/io/file/sql/casetest | 15 | 1329877296 | 88658328 | 1246562064 | |
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 |
|