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 | 3087 | 4652780928730 | 0 | 1507217445 | 270295673080 | 1536 | 30277632 | 19712.0000 | 981 | 39895040 | 40667.7268 | 70172672 | |
sql/io_cache | 402 | 42168754640 | 0 | 104897335 | 16900138620 | 175 | 9683154 | 55332.3086 | 167 | 9683154 | 57982.9581 | 19366308 | |
innodb/innodb_temp_file | 537 | 1127945428130 | 0 | 2100456780 | 107126804910 | 0 | 0 | 0.0000 | 457 | 9453568 | 20686.1444 | 9453568 | |
sql/ERRMSG | 65 | 479693167970 | 2569970 | 7379894635 | 418456812680 | 39 | 3998894 | 102535.7436 | 0 | 0 | 0.0000 | 3998894 | |
innodb/innodb_log_file | 836 | 6019878641110 | 239030 | 7200811610 | 481281253080 | 8 | 70656 | 8832.0000 | 479 | 412672 | 861.5282 | 483328 | |
mysys/charset | 3 | 274994740 | 2430050 | 91664825 | 253426390 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 389 | 186554787980 | 0 | 479575270 | 24749672350 | 90 | 956 | 10.6222 | 11 | 2581 | 234.6364 | 3537 | |
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 |
|