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 | 3047 | 4640713684150 | 0 | 1523043510 | 270295673080 | 1496 | 29622272 | 19800.9840 | 981 | 39895040 | 40667.7268 | 69517312 | |
sql/io_cache | 246 | 34616690830 | 0 | 140718180 | 16900138620 | 94 | 6107646 | 64974.9574 | 107 | 6107646 | 57080.8037 | 12215292 | |
innodb/innodb_temp_file | 437 | 1054772325390 | 0 | 2413666640 | 107126804910 | 0 | 0 | 0.0000 | 361 | 7618560 | 21104.0443 | 7618560 | |
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 | 357 | 186390364490 | 0 | 522101675 | 24749672350 | 82 | 924 | 11.2683 | 11 | 2581 | 234.6364 | 3505 | |
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 |
|