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 | 2904 | 14869227798480 | 5120257296 | 232667263488 | 1355340624 | 411627844848 | 14456244613008 | 8 | 70656 | 8832.0000 | 1772 | 2110976 | 1191.2957 | |
innodb/innodb_data_file | 5301 | 8804675074800 | 1660945968 | 198498515952 | 225742111584 | 117639173520 | 8461293789696 | 1540 | 30343168 | 19703.3558 | 2707 | 94453760 | 34892.4123 | |
sql/binlog | 785 | 1617773979888 | 2060858448 | 33625497312 | 1098772752 | 4371844752 | 1612303362384 | 136 | 1140 | 8.3824 | 117 | 50270 | 429.6581 | |
innodb/innodb_temp_file | 375 | 1467983997744 | 3914623944 | 356247124464 | 0 | 456721049136 | 1011262948608 | 0 | 0 | 0.0000 | 277 | 7684096 | 27740.4188 | |
sql/binlog_index | 38 | 51565640016 | 1356990360 | 34978297728 | 397898160 | 0 | 51167741856 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 27965832576 | 799023720 | 9018566832 | 19548847824 | 0 | 8416984752 | 21 | 2159753 | 102845.3810 | 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 |
|