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 | 401 | 2132496200736 | 5317945512 | 53411284608 | 1090735536 | 41894052288 | 2089511412912 | 8 | 70656 | 8832.0000 | 229 | 207360 | 905.5022 | |
innodb/innodb_data_file | 2107 | 1652910839184 | 784485240 | 255052925424 | 257167908096 | 22837076592 | 1372905854496 | 1307 | 26525696 | 20295.1002 | 528 | 26656768 | 50486.3030 | |
innodb/innodb_temp_file | 293 | 604677266160 | 2063744760 | 33271808064 | 0 | 7776846528 | 596900419632 | 0 | 0 | 0.0000 | 224 | 4915200 | 21942.8571 | |
sql/binlog_index | 38 | 44217743328 | 1163624616 | 24694093248 | 228775008 | 0 | 43988968320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 165 | 42133702512 | 255355584 | 19495037232 | 901816608 | 76851456 | 41155034448 | 38 | 748 | 19.6842 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 60 | 35671948752 | 594532224 | 3930899808 | 18037972656 | 0 | 17633976096 | 36 | 3694649 | 102629.1389 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4205834160 | 525729072 | 2253383088 | 1788136944 | 0 | 2417697216 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 32 | 1062923136 | 33216216 | 771527328 | 1042588800 | 0 | 20334336 | 26 | 1936 | 74.4615 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 993242448 | 124155240 | 643010544 | 964287984 | 0 | 28954464 | 4 | 854 | 213.5000 | 0 | 0 | 0.0000 | |
sql/io_cache | 46 | 984453888 | 21401160 | 90200880 | 98560704 | 592346832 | 293546352 | 16 | 1113480 | 69592.5000 | 20 | 1113480 | 55674.0000 | |
sql/casetest | 15 | 779265696 | 51950976 | 715726704 | 0 | 0 | 779265696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 708786672 | 141757176 | 688565328 | 690146160 | 0 | 18640512 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 290792832 | 96930768 | 274138128 | 274138128 | 0 | 16654704 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 54821712 | 18273816 | 35330064 | 0 | 16422912 | 38398800 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 6 | 38337024 | 6389328 | 13111296 | 5442624 | 0 | 32894400 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 13226928 | 13226928 | 13226928 | 0 | 0 | 13226928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|