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 | 2915 | 4185107049880 | 0 | 1435714085 | 270295673080 | 1490 | 29523968 | 19814.7436 | 899 | 37371904 | 41570.5273 | 66895872 | |
sql/io_cache | 246 | 34616690830 | 0 | 140718180 | 16900138620 | 94 | 6107646 | 64974.9574 | 107 | 6107646 | 57080.8037 | 12215292 | |
innodb/innodb_temp_file | 419 | 946435435080 | 0 | 2258795605 | 107126804910 | 0 | 0 | 0.0000 | 348 | 7077888 | 20338.7586 | 7077888 | |
sql/ERRMSG | 65 | 479693167970 | 2569970 | 7379894635 | 418456812680 | 39 | 3998894 | 102535.7436 | 0 | 0 | 0.0000 | 3998894 | |
innodb/innodb_log_file | 754 | 5521279017930 | 239030 | 7322651190 | 481281253080 | 8 | 70656 | 8832.0000 | 431 | 354304 | 822.0510 | 424960 | |
mysys/charset | 3 | 274994740 | 2430050 | 91664825 | 253426390 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 279 | 173041244950 | 0 | 620219515 | 24749672350 | 63 | 848 | 13.4603 | 10 | 2348 | 234.8000 | 3196 | |
myisam/kfile | 4 | 13141001260 | 968310 | 3285250315 | 13115052990 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 59725884970 | 0 | 1571733815 | 38889092910 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
myisam/dfile | 10 | 344085540 | 267650 | 34408395 | 294038170 | 2 | 123 | 61.5000 | 0 | 0 | 0.0000 | 123 | |
mysys/cnf | 5 | 1757517100 | 155290 | 351503420 | 1741222780 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1086153910 | 2122650 | 271538345 | 617163800 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 55831260 | 2857760 | 18610420 | 34769590 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1017700700 | 0 | 67846625 | 954987390 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 63116640 | 0 | 21038880 | 42848380 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 6 | 653449720 | 0 | 108908110 | 588914800 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|