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 | 1240 | 6662607164928 | 5373070032 | 45864115968 | 1301237520 | 66202488528 | 6595103438880 | 8 | 70656 | 8832.0000 | 716 | 648704 | 906.0112 | |
innodb/innodb_data_file | 3767 | 6494763376992 | 1724120640 | 442351437264 | 277712010576 | 61408572192 | 6155642794224 | 1512 | 29884416 | 19764.8254 | 1538 | 57098240 | 37124.9935 | |
innodb/innodb_temp_file | 1007 | 1716806597616 | 1704872400 | 91830901536 | 0 | 24655173312 | 1692151424304 | 0 | 0 | 0.0000 | 876 | 19660800 | 22443.8356 | |
sql/binlog | 409 | 137774851632 | 336857664 | 21828551184 | 3872441232 | 1667090832 | 132235319568 | 96 | 980 | 10.2083 | 9 | 2590 | 287.7778 | |
sql/io_cache | 1560 | 120516254496 | 77253792 | 27688452528 | 3224738352 | 26919819168 | 90371696976 | 776 | 36522474 | 47065.0438 | 604 | 36522474 | 60467.6722 | |
sql/binlog_index | 38 | 58386764832 | 1536493728 | 34196614848 | 368023392 | 0 | 58018741440 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 70 | 43804221648 | 625774512 | 4946681520 | 24215520384 | 0 | 19588701264 | 42 | 4303959 | 102475.2143 | 0 | 0 | 0.0000 | |
csv/data | 9 | 2247757776 | 249750864 | 1473641136 | 1476547248 | 0 | 771210528 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1973267472 | 394653336 | 1951290000 | 1953310656 | 0 | 19956816 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1621964784 | 202745400 | 503706720 | 986204208 | 0 | 635760576 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1195216704 | 79681008 | 1135176768 | 0 | 0 | 1195216704 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 248448816 | 82816272 | 235575120 | 235575120 | 0 | 12873696 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 80 | 234632640 | 2932776 | 200670096 | 211188912 | 0 | 23443728 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 209028864 | 52257216 | 191114880 | 193010400 | 0 | 16018464 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 52694928 | 17564976 | 41010816 | 0 | 8669232 | 44025696 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 4 | 52522272 | 13130568 | 16958304 | 0 | 0 | 52522272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|