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 | 2226 | 2191919387328 | 0 | 984689640 | 192751033728 | 1228 | 25231360 | 20546.7101 | 680 | 31539200 | 46381.1765 | 56770560 | |
innodb/innodb_temp_file | 144 | 691280061648 | 0 | 4800555936 | 27323192160 | 0 | 0 | 0.0000 | 66 | 2916352 | 44187.1515 | 2916352 | |
sql/ERRMSG | 40 | 28261698432 | 3758304 | 706542408 | 2429384496 | 24 | 2436688 | 101528.6667 | 0 | 0 | 0.0000 | 2436688 | |
sql/io_cache | 30 | 493639872 | 0 | 16454592 | 50701200 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | 1106900 | |
innodb/innodb_log_file | 479 | 2775253315296 | 229152 | 5793848016 | 182032483776 | 8 | 70656 | 8832.0000 | 288 | 348672 | 1210.6667 | 419328 | |
mysys/charset | 3 | 322976016 | 3176976 | 107658672 | 290386800 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 153 | 126067412592 | 0 | 823969872 | 22697415840 | 32 | 724 | 22.6250 | 9 | 1660 | 184.4444 | 2384 | |
sql/binlog_index | 38 | 53830348176 | 0 | 1416588096 | 33716322816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 412410768 | 214368 | 82482048 | 386473296 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13857888 | 625152 | 4619208 | 11360448 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 758800416 | 0 | 50586624 | 655676736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 562969968 | 0 | 187656480 | 538857264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|