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 | 1332 | 7194490819296 | 5401269192 | 45864115968 | 1301237520 | 70668833664 | 7122520748112 | 8 | 70656 | 8832.0000 | 769 | 700928 | 911.4798 | |
innodb/innodb_data_file | 3906 | 7027443214176 | 1799140464 | 442351437264 | 277712010576 | 63732462816 | 6685998740784 | 1512 | 29884416 | 19764.8254 | 1629 | 59817984 | 36720.6777 | |
innodb/innodb_temp_file | 1209 | 1855043124000 | 1534361400 | 91830901536 | 0 | 26264701056 | 1828778422944 | 0 | 0 | 0.0000 | 1070 | 23363584 | 21835.1252 | |
sql/binlog | 427 | 150735417888 | 353010240 | 21828551184 | 3883741488 | 1678586976 | 145173089424 | 100 | 996 | 9.9600 | 10 | 2876 | 287.6000 | |
sql/io_cache | 2060 | 148849886592 | 72257064 | 27688452528 | 4258402896 | 33130478304 | 111461005392 | 1036 | 47793366 | 46132.5927 | 794 | 47793366 | 60193.1562 | |
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 |
|