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 | 1675 | 542987403024 | 324171408 | 173565092448 | 136482314496 | 12586497792 | 393918590736 | 1286 | 26476544 | 20588.2924 | 176 | 15613952 | 88715.6364 | |
innodb/innodb_temp_file | 295 | 483611648256 | 1639361328 | 26614370640 | 0 | 2902349472 | 480709298784 | 0 | 0 | 0.0000 | 224 | 5046272 | 22528.0000 | |
innodb/innodb_log_file | 82 | 350208499872 | 4270835184 | 17520870576 | 1038616128 | 6024285168 | 343145598576 | 8 | 70656 | 8832.0000 | 39 | 64000 | 1641.0256 | |
sql/binlog | 143 | 46501215552 | 325183320 | 21816706560 | 1628592768 | 31484640 | 44841138144 | 34 | 21879 | 643.5000 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 40 | 23525544768 | 588138408 | 4632072720 | 13620336576 | 0 | 9905208192 | 24 | 2444784 | 101866.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 100 | 4106561712 | 41065464 | 1051405344 | 371789088 | 1119801408 | 2614971216 | 36 | 2521826 | 70050.7222 | 44 | 2521826 | 57314.2273 | |
mysys/cnf | 5 | 1375850784 | 275170104 | 1344589488 | 1346383632 | 0 | 29467152 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 833385168 | 36234000 | 314752416 | 501179184 | 0 | 332205984 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 828849120 | 55256520 | 752770656 | 0 | 0 | 828849120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 193439136 | 64479624 | 176899008 | 176899008 | 0 | 16540128 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 35578224 | 11859408 | 30471936 | 0 | 3877632 | 31700592 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 5906736 | 5906736 | 5906736 | 0 | 0 | 5906736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|