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 | 3915 | 6290221663440 | 0 | 1606697664 | 239899935264 | 1614 | 31555584 | 19551.1673 | 1553 | 57032704 | 36724.2138 | 88588288 | |
sql/io_cache | 99 | 4122834672 | 0 | 41644680 | 1189765104 | 32 | 2234772 | 69836.6250 | 42 | 2221650 | 52896.4286 | 4456422 | |
sql/ERRMSG | 65 | 56422462800 | 2841168 | 868037808 | 7387432272 | 39 | 3992068 | 102360.7179 | 0 | 0 | 0.0000 | 3992068 | |
innodb/innodb_temp_file | 220 | 654007679424 | 0 | 2972761968 | 44222973168 | 0 | 0 | 0.0000 | 146 | 3964928 | 27157.0411 | 3964928 | |
innodb/innodb_log_file | 1404 | 8335007039040 | 232848 | 5936614464 | 120659859408 | 8 | 70656 | 8832.0000 | 801 | 584192 | 729.3283 | 654848 | |
mysys/charset | 3 | 223396800 | 2367552 | 74465424 | 209225808 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 16 | 1894428624 | 447744 | 118401624 | 750605856 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog | 383 | 57446729472 | 0 | 149991336 | 18671596944 | 92 | 964 | 10.4783 | 4 | 377 | 94.2500 | 1341 | |
myisam/dfile | 42 | 2699049408 | 1088736 | 64262880 | 1870047696 | 5 | 462 | 92.4000 | 0 | 0 | 0.0000 | 462 | |
sql/binlog_index | 38 | 67242060864 | 0 | 1769527848 | 46226157648 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2435955456 | 946704 | 304494432 | 1162269504 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1680140352 | 190080 | 336027912 | 1663478784 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 28883712 | 1650528 | 9627816 | 22863984 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 726873840 | 0 | 48458256 | 665944224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 14041104 | 0 | 14041104 | 14041104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 41 | 295378512 | 0 | 7204296 | 39066720 | 16 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|