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 | 691 | 3657467036256 | 5293005696 | 45864115968 | 1301237520 | 38052160608 | 3618113638128 | 8 | 70656 | 8832.0000 | 397 | 355840 | 896.3224 | |
innodb/innodb_data_file | 2808 | 3565204123536 | 1269659424 | 442351437264 | 264705475584 | 43499754672 | 3256998893280 | 1460 | 29032448 | 19885.2384 | 900 | 38027264 | 42252.5156 | |
innodb/innodb_temp_file | 529 | 1052646883728 | 1989880464 | 91830901536 | 0 | 11993978304 | 1040652905424 | 0 | 0 | 0.0000 | 439 | 9814016 | 22355.3895 | |
sql/binlog | 143 | 87895697472 | 614655096 | 21828551184 | 3677797200 | 736349328 | 83481550944 | 31 | 720 | 23.2258 | 6 | 1259 | 209.8333 | |
sql/io_cache | 628 | 84394713216 | 134386296 | 27688452528 | 1355604096 | 7363697616 | 75675411504 | 292 | 15366024 | 52623.3699 | 256 | 15366024 | 60023.5313 | |
sql/binlog_index | 38 | 58386764832 | 1536493728 | 34196614848 | 368023392 | 0 | 58018741440 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 28409356800 | 631319040 | 4946681520 | 14439155280 | 0 | 13970201520 | 27 | 2770736 | 102619.8519 | 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 | |
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 |
|