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 | 2577 | 3039682450464 | 0 | 1179543024 | 255763744368 | 1517 | 29966336 | 19753.6823 | 639 | 29442048 | 46075.1925 | 59408384 | |
sql/io_cache | 1030 | 296202479232 | 0 | 287575200 | 116131148496 | 482 | 24287698 | 50389.4149 | 418 | 24278950 | 58083.6124 | 48566648 | |
innodb/innodb_temp_file | 614 | 1770864418224 | 0 | 2884143768 | 572865222864 | 0 | 0 | 0.0000 | 524 | 11206656 | 21386.7481 | 11206656 | |
sql/ERRMSG | 65 | 40737297744 | 2671680 | 626727552 | 2312179584 | 39 | 3987688 | 102248.4103 | 0 | 0 | 0.0000 | 3987688 | |
innodb/innodb_log_file | 543 | 3269335263216 | 232848 | 6020875080 | 96851922816 | 8 | 70656 | 8832.0000 | 305 | 245760 | 805.7705 | 316416 | |
mysys/charset | 3 | 293225328 | 2303136 | 97741776 | 276990384 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 841 | 59401094544 | 0 | 70631352 | 33895667520 | 207 | 1424 | 6.8792 | 3 | 156 | 52.0000 | 1580 | |
myisam/kfile | 4 | 1420658976 | 1872816 | 355164744 | 1360588416 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 49923225264 | 0 | 1313769072 | 30804492576 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1244412048 | 340560 | 248882304 | 1221739728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49250256 | 2774640 | 16416576 | 35327952 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 845012256 | 0 | 56333904 | 753700464 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 7064640 | 0 | 7064640 | 7064640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 3 | 39615840 | 1130976 | 13205280 | 28630272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|