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 | 1279 | 6650679688752 | 5199905832 | 41118052800 | 1696165680 | 171808400016 | 6477175123056 | 8 | 70656 | 8832.0000 | 773 | 790528 | 1022.6753 | |
innodb/innodb_data_file | 3690 | 4441298263248 | 1203603720 | 220174262352 | 398100677568 | 52156328928 | 3991041256752 | 1457 | 28983296 | 19892.4475 | 1666 | 62504960 | 37517.9832 | |
innodb/innodb_temp_file | 123 | 537643256304 | 4371083376 | 27228813216 | 0 | 3245836704 | 534397419600 | 0 | 0 | 0.0000 | 53 | 2179072 | 41114.5660 | |
sql/binlog | 601 | 241690854768 | 402147768 | 33466219248 | 1377290112 | 814606848 | 239498957808 | 143 | 1462 | 10.2238 | 14 | 3564 | 254.5714 | |
sql/ERRMSG | 65 | 74151371184 | 1140790200 | 31722260592 | 25772658912 | 0 | 48378712272 | 39 | 4001064 | 102591.3846 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 44794263888 | 1178796168 | 23338890432 | 935188848 | 0 | 43859075040 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 38 | 2399996016 | 63157776 | 849145968 | 105328608 | 690932352 | 1603735056 | 10 | 987224 | 98722.4000 | 18 | 987224 | 54845.7778 | |
sql/casetest | 15 | 705055824 | 47003616 | 641580720 | 0 | 0 | 705055824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 624240144 | 124847976 | 594510048 | 595675344 | 0 | 28564800 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 521548896 | 130387224 | 447570288 | 447570288 | 0 | 73978608 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 356274336 | 89068584 | 338605344 | 340816608 | 0 | 15457728 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 350567184 | 116855640 | 330839520 | 330839520 | 0 | 19727664 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 175284912 | 87642456 | 165600336 | 0 | 0 | 175284912 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 76115952 | 12685992 | 18099312 | 0 | 0 | 76115952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46331472 | 15443736 | 36649008 | 0 | 7292208 | 39039264 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 9592704 | 4796352 | 7053552 | 0 | 0 | 9592704 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|