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 | 1018 | 5339106912480 | 5244702144 | 45864115968 | 1301237520 | 47002572672 | 5290803102288 | 8 | 70656 | 8832.0000 | 588 | 529920 | 901.2245 | |
innodb/innodb_data_file | 3373 | 5295073059936 | 1569840624 | 442351437264 | 274021375584 | 54721544592 | 4966330139760 | 1508 | 29818880 | 19773.7931 | 1265 | 48939008 | 38686.9628 | |
innodb/innodb_temp_file | 779 | 1442667735696 | 1851948120 | 91830901536 | 0 | 15305197776 | 1427362537920 | 0 | 0 | 0.0000 | 665 | 15089664 | 22691.2241 | |
sql/io_cache | 1216 | 115284912336 | 94806624 | 27688452528 | 2600989248 | 23771484528 | 88912438560 | 604 | 28686544 | 47494.2781 | 472 | 28686544 | 60776.5763 | |
sql/binlog | 325 | 108050191920 | 332462064 | 21828551184 | 3811118256 | 1181289648 | 103057784016 | 76 | 900 | 11.8421 | 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 |
|