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 | 1080 | 5719539064800 | 5295869304 | 45864115968 | 1301237520 | 48539420160 | 5669698407120 | 8 | 70656 | 8832.0000 | 622 | 555008 | 892.2958 | |
innodb/innodb_data_file | 3447 | 5598796615104 | 1624251816 | 442351437264 | 274021375584 | 55865805600 | 5268909433920 | 1508 | 29818880 | 19773.7931 | 1309 | 50151424 | 38312.7762 | |
innodb/innodb_temp_file | 821 | 1491650331072 | 1816869912 | 91830901536 | 0 | 22409383392 | 1469240947680 | 0 | 0 | 0.0000 | 704 | 15925248 | 22621.0909 | |
sql/io_cache | 1216 | 115284912336 | 94806624 | 27688452528 | 2600989248 | 23771484528 | 88912438560 | 604 | 28686544 | 47494.2781 | 472 | 28686544 | 60776.5763 | |
sql/binlog | 337 | 108120839904 | 320833128 | 21828551184 | 3820880976 | 1181289648 | 103118669280 | 79 | 912 | 11.5443 | 7 | 1977 | 282.4286 | |
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 | 3 | 42452784 | 14150928 | 16958304 | 0 | 0 | 42452784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|