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_data_file | 1835 | 1659932282976 | 904595208 | 442351437264 | 220521168912 | 25568129136 | 1413842984928 | 1295 | 26329088 | 20331.3421 | 306 | 19677184 | 64304.5229 | |
innodb/innodb_log_file | 270 | 1366339689264 | 5060517264 | 45864115968 | 1301237520 | 19426691328 | 1345611760416 | 8 | 70656 | 8832.0000 | 151 | 137216 | 908.7152 | |
innodb/innodb_temp_file | 131 | 455375431104 | 3476148192 | 30849951792 | 0 | 7485789696 | 447889641408 | 0 | 0 | 0.0000 | 68 | 1966080 | 28912.9412 | |
sql/binlog_index | 38 | 58386764832 | 1536493728 | 34196614848 | 368023392 | 0 | 58018741440 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 61 | 43578698064 | 714404856 | 21828551184 | 1259009664 | 53040240 | 42266648160 | 12 | 644 | 53.6667 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 30 | 22674713952 | 755823552 | 4946681520 | 11437431456 | 0 | 11237282496 | 18 | 1848594 | 102699.6667 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1973267472 | 394653336 | 1951290000 | 1953310656 | 0 | 19956816 | 3 | 56 | 18.6667 | 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 | |
sql/pid | 3 | 52694928 | 17564976 | 41010816 | 0 | 8669232 | 44025696 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 13492512 | 13492512 | 13492512 | 0 | 0 | 13492512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|