SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 1542 | 8810460037104 | 5713657488 | 151293090432 | 1148062608 | 346468207536 | 8462843766960 | 8 | 70656 | 8832.0000 | 931 | 1099264 | 1180.7347 | |
innodb/innodb_data_file | 3926 | 5923606304352 | 1508814384 | 208012862112 | 276821326848 | 69782331696 | 5577002645808 | 1572 | 30867456 | 19635.7863 | 1660 | 62177280 | 37456.1928 | |
innodb/innodb_temp_file | 170 | 994478199264 | 5849871720 | 127632673872 | 0 | 3021654240 | 991456545024 | 0 | 0 | 0.0000 | 85 | 3686400 | 43369.4118 | |
sql/binlog | 401 | 377818300464 | 942190128 | 23508215808 | 1194914688 | 3026105280 | 373597280496 | 85 | 936 | 11.0118 | 27 | 8687 | 321.7407 | |
sql/ERRMSG | 75 | 61696890288 | 822625056 | 5665795872 | 32290660512 | 0 | 29406229776 | 45 | 4606508 | 102366.8444 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 51206038752 | 1347527280 | 34578879456 | 474857328 | 0 | 50731181424 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 94 | 4484607600 | 47708496 | 1647132432 | 356057328 | 1847250240 | 2281300032 | 46 | 2280572 | 49577.6522 | 38 | 2280572 | 60015.0526 | |
sql/casetest | 15 | 888087024 | 59205696 | 816213024 | 0 | 0 | 888087024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 791587104 | 158317368 | 756155136 | 757950864 | 0 | 33636240 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 4 | 757316208 | 189328920 | 719632320 | 0 | 0 | 757316208 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 523917504 | 65489688 | 219400368 | 361181568 | 0 | 162735936 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 489809760 | 122452440 | 473525712 | 475466112 | 0 | 14343648 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 244498848 | 81499440 | 222864576 | 222864576 | 0 | 21634272 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 11 | 160286016 | 14571216 | 29466624 | 0 | 0 | 160286016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 6 | 20720832 | 3453384 | 9510864 | 0 | 0 | 20720832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13318800 | 4439424 | 10737408 | 0 | 1844304 | 11474496 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|