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 | 2922 | 3878076463536 | 0 | 1327199280 | 264024407328 | 1480 | 29360128 | 19837.9243 | 990 | 41041920 | 41456.4848 | 70402048 | |
sql/ERRMSG | 55 | 25467483888 | 2510112 | 463044912 | 2538897504 | 33 | 3380315 | 102433.7879 | 0 | 0 | 0.0000 | 3380315 | |
innodb/innodb_temp_file | 129 | 605508767424 | 0 | 4693866408 | 26370581952 | 0 | 0 | 0.0000 | 57 | 2375680 | 41678.5965 | 2375680 | |
innodb/innodb_log_file | 882 | 5452799762784 | 237600 | 6182312400 | 212821987488 | 8 | 70656 | 8832.0000 | 520 | 492544 | 947.2000 | 563200 | |
mysys/charset | 3 | 228560640 | 2232912 | 76186704 | 214938240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 364 | 545993093712 | 0 | 1499980944 | 28586943792 | 70 | 1023 | 14.6143 | 40 | 11735 | 293.3750 | 12758 | |
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 |
|