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 | 3944 | 6885458833440 | 0 | 1745805864 | 571387074192 | 1431 | 28557312 | 19956.1929 | 1839 | 68599808 | 37302.7776 | 97157120 | |
sql/io_cache | 610 | 79320832800 | 0 | 130033992 | 46032174144 | 273 | 14914340 | 54631.2821 | 252 | 14914340 | 59183.8889 | 29828680 | |
innodb/innodb_temp_file | 556 | 982772668416 | 0 | 1767576624 | 33957724944 | 0 | 0 | 0.0000 | 471 | 10010624 | 21253.9788 | 10010624 | |
sql/ERRMSG | 30 | 14700980976 | 2742432 | 490032576 | 2261898672 | 18 | 1848594 | 102699.6667 | 0 | 0 | 0.0000 | 1848594 | |
innodb/innodb_log_file | 2050 | 11527776245568 | 228096 | 5623305336 | 331110904080 | 8 | 70656 | 8832.0000 | 1269 | 1642496 | 1294.3231 | 1713152 | |
mysys/charset | 3 | 313766112 | 2335872 | 104588616 | 298498992 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 355 | 831939091632 | 0 | 2343490248 | 85127343312 | 64 | 852 | 13.3125 | 46 | 15345 | 333.5870 | 16197 | |
myisam/kfile | 4 | 706513104 | 3382896 | 176628144 | 571026192 | 2 | 407 | 203.5000 | 0 | 0 | 0.0000 | 407 | |
sql/binlog_index | 38 | 60269444928 | 0 | 1586037816 | 34542932160 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 372500304 | 203280 | 74500008 | 356083728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
myisam/dfile | 6 | 614472144 | 1472592 | 102411936 | 563659008 | 1 | 39 | 39.0000 | 0 | 0 | 0.0000 | 39 | |
csv/metadata | 4 | 438409488 | 979968 | 109602240 | 349562928 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 16781952 | 752400 | 5593896 | 11857824 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 695774640 | 0 | 46384800 | 631533936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 62894832 | 0 | 12578808 | 26779104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 33 | 417243552 | 0 | 12643488 | 184123104 | 13 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|