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 | 2281 | 11511885787248 | 5046858960 | 232667263488 | 1355340624 | 375159700080 | 11135370746544 | 8 | 70656 | 8832.0000 | 1405 | 1805824 | 1285.2840 | |
innodb/innodb_data_file | 4420 | 6665731561632 | 1508083896 | 198498515952 | 224482231776 | 98828996640 | 6342420333216 | 1535 | 30261248 | 19714.1681 | 2070 | 75186176 | 36321.8242 | |
sql/binlog | 527 | 1144358003712 | 2171457288 | 33625497312 | 945417264 | 2326523760 | 1141086062688 | 89 | 952 | 10.6966 | 82 | 35096 | 428.0000 | |
innodb/innodb_temp_file | 299 | 1126839191280 | 3768692928 | 356247124464 | 0 | 391046329872 | 735792861408 | 0 | 0 | 0.0000 | 216 | 5701632 | 26396.4444 | |
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 |
|