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 | 3941 | 8281978300464 | 0 | 2101491480 | 257666291520 | 1334 | 26968064 | 20215.9400 | 1812 | 65683456 | 36249.1479 | 92651520 | |
sql/io_cache | 104 | 8867115840 | 0 | 85260648 | 5689449216 | 42 | 2339786 | 55709.1905 | 42 | 2339786 | 55709.1905 | 4679572 | |
sql/ERRMSG | 60 | 42647293392 | 3622608 | 710788056 | 3923430720 | 36 | 3685274 | 102368.7222 | 0 | 0 | 0.0000 | 3685274 | |
innodb/innodb_temp_file | 170 | 919738333008 | 0 | 5410225392 | 37880610240 | 0 | 0 | 0.0000 | 86 | 3637248 | 42293.5814 | 3637248 | |
innodb/innodb_log_file | 1610 | 10070413683264 | 238656 | 6254915304 | 737741315520 | 8 | 70656 | 8832.0000 | 962 | 1132544 | 1177.2807 | 1203200 | |
mysys/charset | 3 | 285315888 | 2225520 | 95105208 | 269060352 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 463 | 606963156624 | 0 | 1310935296 | 29250269136 | 95 | 976 | 10.2737 | 38 | 14495 | 381.4474 | 15471 | |
myisam/kfile | 4 | 491332512 | 531168 | 122833128 | 476462448 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 52182211488 | 0 | 1373216064 | 31798136304 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 616837584 | 205920 | 123367464 | 595464144 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 46841520 | 2643168 | 15613752 | 35846448 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 814121088 | 0 | 54274704 | 741818880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 9 | 167114112 | 0 | 18568176 | 70083024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 6668112 | 343728 | 3334056 | 6324384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|