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 | 6527 | 30649698761088 | 4695832416 | 235840140624 | 1147281168 | 1056828267792 | 29591723212128 | 8 | 70656 | 8832.0000 | 4312 | 8783872 | 2037.0761 | |
innodb/innodb_data_file | 5218 | 13560269537760 | 2598748416 | 208855237536 | 320038463184 | 217525661232 | 13022705413344 | 1520 | 30015488 | 19747.0316 | 2245 | 89014272 | 39650.0098 | |
sql/binlog | 904 | 2899625898048 | 3207550632 | 41664398688 | 864351840 | 7059739104 | 2891701807104 | 115 | 1056 | 9.1826 | 232 | 363625 | 1567.3491 | |
innodb/innodb_temp_file | 198 | 959348483808 | 4845194112 | 32295199728 | 0 | 3504128496 | 955844355312 | 0 | 0 | 0.0000 | 104 | 4587520 | 44110.7692 | |
sql/binlog_index | 38 | 42855463200 | 1127775264 | 25978303824 | 424070592 | 0 | 42431392608 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 31998846000 | 581797128 | 4959332400 | 18575191536 | 0 | 13423654464 | 33 | 3381351 | 102465.1818 | 0 | 0 | 0.0000 | |
sql/SDI | 6 | 5417065632 | 902844096 | 3988114944 | 0 | 37298448 | 5379767184 | 0 | 0 | 0.0000 | 2 | 23572 | 11786.0000 | |
csv/metadata | 8 | 3199777680 | 399972144 | 1846784544 | 1009773600 | 0 | 2190004080 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 46 | 2481252048 | 53940216 | 1141557120 | 2318686128 | 29103888 | 133462032 | 8 | 1703 | 212.8750 | 27 | 451 | 16.7037 | |
csv/data | 4 | 1327861920 | 331965480 | 1247834544 | 0 | 0 | 1327861920 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 158 | 1056586608 | 6687120 | 448511184 | 79187856 | 264199056 | 713199696 | 10 | 178759 | 17875.9000 | 10 | 178759 | 17875.9000 | |
sql/casetest | 15 | 766813872 | 51120696 | 682016016 | 0 | 0 | 766813872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 543032160 | 108606432 | 510144096 | 511360608 | 0 | 31671552 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 260141376 | 86713704 | 243798720 | 243798720 | 0 | 16342656 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 8 | 127149264 | 15893592 | 31319376 | 0 | 0 | 127149264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 10 | 66335280 | 6633528 | 26558400 | 0 | 0 | 66335280 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14438688 | 4812720 | 11480304 | 0 | 2245056 | 12193632 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|