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 | 2984 | 15306709234608 | 5129594184 | 232667263488 | 1355340624 | 413046876528 | 14892307017456 | 8 | 70656 | 8832.0000 | 1817 | 2142720 | 1179.2625 | |
innodb/innodb_data_file | 5399 | 9280899616560 | 1719003264 | 198498515952 | 225742111584 | 118872328080 | 8936285176896 | 1540 | 30343168 | 19703.3558 | 2765 | 96092160 | 34753.0416 | |
innodb/innodb_temp_file | 415 | 2012127143136 | 4848499128 | 430788258912 | 0 | 944350753632 | 1067776389504 | 0 | 0 | 0.0000 | 313 | 8536064 | 27271.7700 | |
sql/binlog | 865 | 1618203922896 | 1870755744 | 33625497312 | 1172344272 | 4371844752 | 1612659733872 | 156 | 1220 | 7.8205 | 117 | 50270 | 429.6581 | |
sql/binlog_index | 38 | 51565640016 | 1356990360 | 34978297728 | 397898160 | 0 | 51167741856 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 34133476608 | 758521632 | 9018566832 | 22671706992 | 0 | 11461769616 | 27 | 2770736 | 102619.8519 | 0 | 0 | 0.0000 | |
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 | |
sql/casetest | 15 | 910048128 | 60669840 | 839172576 | 0 | 0 | 910048128 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 864723024 | 216180624 | 805551648 | 0 | 0 | 864723024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 618404160 | 154601040 | 594906048 | 596835888 | 0 | 21568272 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 311083872 | 103694448 | 293603904 | 0 | 0 | 311083872 | 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 | |
sql/pid | 3 | 12713712 | 4237728 | 10369392 | 0 | 1737648 | 10976064 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 9832944 | 4916472 | 9354576 | 0 | 0 | 9832944 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|