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 | 925 | 4842072205872 | 5234672520 | 45864115968 | 1301237520 | 40975501248 | 4799795467104 | 8 | 70656 | 8832.0000 | 530 | 451584 | 852.0453 | |
innodb/innodb_data_file | 3225 | 4762700433744 | 1476806232 | 442351437264 | 274021375584 | 47821155360 | 4440857902800 | 1508 | 29818880 | 19773.7931 | 1161 | 45760512 | 39414.7390 | |
innodb/innodb_temp_file | 752 | 1320481393968 | 1755959040 | 91830901536 | 0 | 14584270800 | 1305897123168 | 0 | 0 | 0.0000 | 646 | 14254080 | 22065.1393 | |
sql/io_cache | 1118 | 103559677584 | 92629152 | 27688452528 | 2340826224 | 12791526528 | 88427324832 | 552 | 26463708 | 47941.5000 | 436 | 26463708 | 60696.5780 | |
sql/binlog | 251 | 88444136880 | 352366872 | 21828551184 | 3757508832 | 736349328 | 83950278720 | 58 | 828 | 14.2759 | 6 | 1259 | 209.8333 | |
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 |
|