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 | 3331 | 6019622257440 | 0 | 1807151544 | 257666291520 | 1316 | 26673152 | 20268.3526 | 1423 | 54214656 | 38098.8447 | 80887808 | |
sql/ERRMSG | 45 | 33971400144 | 3622608 | 754919880 | 3923430720 | 27 | 2769072 | 102558.2222 | 0 | 0 | 0.0000 | 2769072 | |
innodb/innodb_temp_file | 140 | 697408421952 | 0 | 4981488600 | 37880610240 | 0 | 0 | 0.0000 | 65 | 2703360 | 41590.1538 | 2703360 | |
sql/io_cache | 30 | 1443843456 | 0 | 48127992 | 493423392 | 8 | 611830 | 76478.7500 | 12 | 611830 | 50985.8333 | 1223660 | |
innodb/innodb_log_file | 1221 | 7616765734512 | 238656 | 6238137312 | 737741315520 | 8 | 70656 | 8832.0000 | 733 | 914432 | 1247.5198 | 985088 | |
mysys/charset | 3 | 285315888 | 2225520 | 95105208 | 269060352 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 333 | 515435102160 | 0 | 1547853120 | 26833340688 | 65 | 856 | 13.1692 | 33 | 12836 | 388.9697 | 13692 | |
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 | 8 | 155488080 | 0 | 19435944 | 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 |
|