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 | 1521 | 8003876745744 | 5262246264 | 173132781360 | 1147281168 | 365116162224 | 7637613302352 | 8 | 70656 | 8832.0000 | 947 | 1238016 | 1307.3031 | |
innodb/innodb_data_file | 3623 | 5136102407568 | 1417637760 | 208855237536 | 302063384304 | 73433453808 | 4760605569456 | 1484 | 29425664 | 19828.6146 | 1495 | 57458688 | 38433.9050 | |
sql/binlog | 335 | 609845383488 | 1820433912 | 36903527760 | 536052528 | 1331413776 | 607977917184 | 61 | 840 | 13.7705 | 42 | 14014 | 333.6667 | |
innodb/innodb_temp_file | 128 | 555665317680 | 4341135216 | 32295199728 | 0 | 1922808624 | 553742509056 | 0 | 0 | 0.0000 | 56 | 2359296 | 42130.2857 | |
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 | |
csv/metadata | 8 | 3199777680 | 399972144 | 1846784544 | 1009773600 | 0 | 2190004080 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 2418046752 | 151127856 | 1141557120 | 2318686128 | 0 | 99360624 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
csv/data | 4 | 1327861920 | 331965480 | 1247834544 | 0 | 0 | 1327861920 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
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 | 7 | 111338832 | 15905472 | 31319376 | 0 | 0 | 111338832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 8 | 54425712 | 6803016 | 26558400 | 0 | 0 | 54425712 | 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 |
|