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 | 2185 | 1342196304768 | 0 | 614277312 | 247880998992 | 1329 | 26886144 | 20230.3567 | 645 | 30720000 | 47627.9070 | 57606144 | |
sql/io_cache | 257 | 7225846848 | 0 | 28116000 | 483589920 | 98 | 6240664 | 63680.2449 | 109 | 6240664 | 57253.7982 | 12481328 | |
innodb/innodb_temp_file | 353 | 797826939360 | 0 | 2260132776 | 172757455728 | 0 | 0 | 0.0000 | 285 | 5849088 | 20523.1158 | 5849088 | |
sql/ERRMSG | 55 | 30839317872 | 2583504 | 560714616 | 6359769504 | 33 | 3372268 | 102189.9394 | 0 | 0 | 0.0000 | 3372268 | |
innodb/innodb_log_file | 500 | 2795279312496 | 222288 | 5590558512 | 121090283952 | 8 | 70656 | 8832.0000 | 296 | 260096 | 878.7027 | 330752 | |
mysys/charset | 3 | 244346784 | 2163744 | 81448752 | 230783520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 49 | 35293908144 | 0 | 720283608 | 16335265056 | 9 | 632 | 70.2222 | 3 | 156 | 52.0000 | 788 | |
sql/binlog_index | 38 | 63895558848 | 0 | 1681461936 | 46462317264 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 322851936 | 294624 | 64570176 | 302522880 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 413811552 | 586608 | 103452888 | 341303424 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 13036320 | 655248 | 4345440 | 10763808 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 916722576 | 0 | 61114680 | 852414816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 12513600 | 0 | 12513600 | 12513600 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 16416576 | 0 | 8208288 | 10652928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|