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 | 2517 | 1838879611008 | 0 | 730583832 | 247880998992 | 1361 | 27410432 | 20139.9206 | 890 | 38387712 | 43132.2607 | 65798144 | |
sql/io_cache | 409 | 21187900272 | 0 | 51803928 | 11490414672 | 168 | 9882156 | 58822.3571 | 171 | 9882156 | 57790.3860 | 19764312 | |
innodb/innodb_temp_file | 404 | 868366134240 | 0 | 2149420944 | 172757455728 | 0 | 0 | 0.0000 | 332 | 6881280 | 20726.7470 | 6881280 | |
sql/ERRMSG | 55 | 30839317872 | 2583504 | 560714616 | 6359769504 | 33 | 3372268 | 102189.9394 | 0 | 0 | 0.0000 | 3372268 | |
innodb/innodb_log_file | 651 | 3491600778336 | 222288 | 5363441952 | 121090283952 | 8 | 70656 | 8832.0000 | 385 | 326656 | 848.4571 | 397312 | |
mysys/charset | 3 | 244346784 | 2163744 | 81448752 | 230783520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 71 | 51066459840 | 0 | 719245824 | 16335265056 | 14 | 652 | 46.5714 | 4 | 429 | 107.2500 | 1081 | |
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 | 2 | 24870384 | 0 | 12435192 | 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 |
|