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 | 328 | 1762548683808 | 5373623904 | 39946946688 | 1421607264 | 32363929488 | 1728763147056 | 8 | 70656 | 8832.0000 | 191 | 176640 | 924.8168 | |
innodb/innodb_data_file | 2163 | 1619050404576 | 748520520 | 251350017072 | 254912527584 | 31658772816 | 1332479104176 | 1369 | 27541504 | 20117.9722 | 530 | 26755072 | 50481.2679 | |
innodb/innodb_temp_file | 102 | 452903779680 | 4440232896 | 30903630384 | 0 | 2963432736 | 449940346944 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | |
sql/binlog | 135 | 59097172464 | 437756616 | 19057350048 | 1118950800 | 690480384 | 57287741280 | 30 | 716 | 23.8667 | 4 | 353 | 88.2500 | |
sql/binlog_index | 38 | 44556027648 | 1172526960 | 24308389776 | 1735221840 | 0 | 42820805808 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 30 | 15918603888 | 530619936 | 3043046160 | 10884647136 | 0 | 5033956752 | 18 | 1849990 | 102777.2222 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 830573040 | 166114608 | 811062912 | 812941008 | 0 | 17632032 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 771825120 | 96478008 | 371877792 | 600231456 | 0 | 171593664 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 724370064 | 48291144 | 662167968 | 0 | 0 | 724370064 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 290371488 | 96790320 | 271135920 | 271135920 | 0 | 19235568 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 258392112 | 64597896 | 206444832 | 0 | 0 | 258392112 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47827824 | 15942432 | 37167504 | 0 | 8022960 | 39804864 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 31074384 | 15537192 | 17895504 | 0 | 0 | 31074384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|