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 | 2939 | 3997118158176 | 0 | 1360026360 | 264024407328 | 1480 | 29360128 | 19837.9243 | 999 | 41271296 | 41312.6086 | 70631424 | |
sql/ERRMSG | 60 | 26523761088 | 2510112 | 442062456 | 2538897504 | 36 | 3686782 | 102410.6111 | 0 | 0 | 0.0000 | 3686782 | |
innodb/innodb_temp_file | 129 | 605508767424 | 0 | 4693866408 | 26370581952 | 0 | 0 | 0.0000 | 57 | 2375680 | 41678.5965 | 2375680 | |
innodb/innodb_log_file | 895 | 5545257486912 | 237600 | 6195818376 | 212821987488 | 8 | 70656 | 8832.0000 | 527 | 496128 | 941.4194 | 566784 | |
mysys/charset | 3 | 228560640 | 2232912 | 76186704 | 214938240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 396 | 546157975968 | 0 | 1379186688 | 28586943792 | 78 | 1055 | 13.5256 | 40 | 11735 | 293.3750 | 12790 | |
myisam/kfile | 4 | 568837104 | 585024 | 142209144 | 551122176 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 60573022752 | 0 | 1594026720 | 40847173488 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 13819332384 | 1877040 | 1727416416 | 12210742896 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1260207696 | 273504 | 252041328 | 1235320944 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 58526160 | 3426720 | 19508544 | 37677552 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1055232816 | 0 | 70348608 | 979285824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 7 | 141035136 | 0 | 20147688 | 52822704 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 759316272 | 0 | 189828936 | 654167184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 7395696 | 748704 | 3697848 | 6646992 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|