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 | 2386 | 2464128343248 | 0 | 1032744240 | 233836900176 | 1312 | 26607616 | 20280.1951 | 744 | 33210368 | 44637.5914 | 59817984 | |
innodb/innodb_temp_file | 182 | 1038227719584 | 0 | 5704547904 | 44894684208 | 0 | 0 | 0.0000 | 91 | 4177920 | 45911.2088 | 4177920 | |
sql/ERRMSG | 50 | 24731267088 | 3322704 | 494625120 | 3018120336 | 30 | 3075875 | 102529.1667 | 0 | 0 | 0.0000 | 3075875 | |
innodb/innodb_log_file | 546 | 3359020652064 | 234432 | 6152052456 | 65659462176 | 8 | 70656 | 8832.0000 | 315 | 262656 | 833.8286 | 333312 | |
mysys/charset | 3 | 261599712 | 1801536 | 87199728 | 248046480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 303 | 910058325792 | 0 | 3003492624 | 821846886960 | 71 | 880 | 12.3944 | 6 | 870 | 145.0000 | 1750 | |
myisam/kfile | 4 | 1708586880 | 554400 | 427146720 | 1694168784 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 46005701280 | 0 | 1210676280 | 23245539504 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1700192208 | 587664 | 212523960 | 968011968 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 514212336 | 344784 | 102842256 | 496863840 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 50063904 | 3143712 | 16687968 | 38884560 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1084377888 | 0 | 72291648 | 1022525328 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 135902976 | 0 | 33975744 | 102449424 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 571258512 | 0 | 142814496 | 511008432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 18196992 | 8283264 | 9098496 | 9913728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|