SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 2449 | 2648150464608 | 0 | 1081318920 | 222522112560 | 1404 | 28114944 | 20024.8889 | 658 | 30097408 | 45740.7416 | 58212352 | |
sql/io_cache | 569 | 15604970832 | 0 | 27425112 | 1613949216 | 233 | 13773804 | 59115.0386 | 241 | 13773804 | 57152.7137 | 27547608 | |
sql/ERRMSG | 95 | 57977145600 | 2573472 | 610285632 | 3065770752 | 57 | 5825714 | 102205.5088 | 0 | 0 | 0.0000 | 5825714 | |
innodb/innodb_temp_file | 254 | 1174422942000 | 0 | 4623712368 | 302618190336 | 0 | 0 | 0.0000 | 172 | 4915200 | 28576.7442 | 4915200 | |
innodb/innodb_log_file | 534 | 2911374148848 | 217536 | 5452011312 | 56015720640 | 8 | 70656 | 8832.0000 | 303 | 252928 | 834.7459 | 323584 | |
mysys/charset | 3 | 313964112 | 2215488 | 104654616 | 293019408 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 783 | 97099626624 | 0 | 124009512 | 27899104464 | 192 | 1364 | 7.1042 | 4 | 429 | 107.2500 | 1793 | |
myisam/kfile | 12 | 1830530592 | 586608 | 152544216 | 820162464 | 6 | 1261 | 210.1667 | 0 | 0 | 0.0000 | 1261 | |
sql/binlog_index | 38 | 52091725488 | 0 | 1370834784 | 27662809152 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1604048160 | 790416 | 200505888 | 952451808 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 800064672 | 267168 | 160012776 | 780142176 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 44196768 | 2317920 | 14732256 | 34419792 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1090185888 | 0 | 72678936 | 1026658512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 48558048 | 0 | 24279024 | 33100848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 567774240 | 0 | 141943560 | 505132320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 6 | 26580576 | 276144 | 4429920 | 11594880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|