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 | 1929 | 1862519881200 | 0 | 965536440 | 269829479040 | 1305 | 26492928 | 20301.0943 | 337 | 20201472 | 59945.0208 | 46694400 | |
sql/io_cache | 282 | 1132367119488 | 0 | 4015486200 | 832686507312 | 112 | 6833468 | 61013.1071 | 120 | 6833468 | 56945.5667 | 13666936 | |
innodb/innodb_temp_file | 398 | 661802306352 | 0 | 1662819840 | 131335730064 | 0 | 0 | 0.0000 | 333 | 6438912 | 19336.0721 | 6438912 | |
sql/ERRMSG | 65 | 33999000816 | 2542320 | 523061352 | 3939387408 | 39 | 3991974 | 102358.3077 | 0 | 0 | 0.0000 | 3991974 | |
innodb/innodb_log_file | 284 | 1880256429216 | 220704 | 6620621040 | 275721548256 | 8 | 70656 | 8832.0000 | 156 | 140800 | 902.5641 | 211456 | |
mysys/charset | 3 | 278258112 | 2277264 | 92752704 | 263420784 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 209 | 68987485248 | 0 | 330083424 | 19399580112 | 48 | 788 | 16.4167 | 5 | 669 | 133.8000 | 1457 | |
sql/binlog_index | 38 | 59146598544 | 0 | 1556489352 | 29259051360 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 538168752 | 243408 | 107633592 | 519755808 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 17259792 | 792528 | 5753088 | 14131392 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 937200000 | 0 | 62479824 | 875165808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 498614688 | 0 | 166204896 | 473155056 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|