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 | 5891 | 28604466673728 | 4855621320 | 232667263488 | 1355340624 | 863535233616 | 27739576099488 | 8 | 70656 | 8832.0000 | 3720 | 5517824 | 1483.2860 | |
innodb/innodb_data_file | 8411 | 14703669917904 | 1748147544 | 198498515952 | 247927457712 | 204202391712 | 14251540068480 | 1587 | 31113216 | 19605.0510 | 4899 | 163135488 | 33299.7526 | |
innodb/innodb_temp_file | 578 | 2909144348880 | 5033121456 | 430788258912 | 0 | 948419076528 | 1960725272352 | 0 | 0 | 0.0000 | 423 | 13811712 | 32651.8014 | |
sql/binlog | 1705 | 2663018134128 | 1561887360 | 33625497312 | 1695695760 | 5935690992 | 2655386747376 | 327 | 1904 | 5.8226 | 195 | 74629 | 382.7128 | |
sql/binlog_index | 38 | 51565640016 | 1356990360 | 34978297728 | 397898160 | 0 | 51167741856 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 40030779888 | 727832160 | 9018566832 | 24832627248 | 0 | 15198152640 | 33 | 3380780 | 102447.8788 | 0 | 0 | 0.0000 | |
sql/io_cache | 48 | 8163907488 | 170081208 | 7347689184 | 100704912 | 463958352 | 7599244224 | 16 | 1238178 | 77386.1250 | 22 | 1238178 | 56280.8182 | |
csv/metadata | 8 | 4179483264 | 522435408 | 1603221312 | 1322795232 | 0 | 2856688032 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1336449312 | 267289704 | 1318897536 | 1320156288 | 0 | 16293024 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 9 | 1158915648 | 128768376 | 805551648 | 277576992 | 0 | 881338656 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 9 | 998348736 | 110927520 | 594906048 | 596835888 | 0 | 401512848 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 910048128 | 60669840 | 839172576 | 0 | 0 | 910048128 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 8 | 590682576 | 73835256 | 293603904 | 0 | 0 | 590682576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 304270560 | 101423520 | 262034784 | 262034784 | 0 | 42235776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 49837392 | 7119552 | 16358496 | 0 | 0 | 49837392 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12713712 | 4237728 | 10369392 | 0 | 1737648 | 10976064 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|