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 | 2917 | 4256477653296 | 0 | 1459196904 | 571387074192 | 1399 | 28033024 | 20037.9014 | 1078 | 44744704 | 41507.1466 | 72777728 | |
sql/io_cache | 316 | 24866974704 | 0 | 78692856 | 7002994416 | 133 | 7755076 | 58308.8421 | 133 | 7755076 | 58308.8421 | 15510152 | |
innodb/innodb_temp_file | 228 | 605022602448 | 0 | 2653607880 | 26596775568 | 0 | 0 | 0.0000 | 162 | 3702784 | 22856.6914 | 3702784 | |
sql/ERRMSG | 30 | 14700980976 | 2742432 | 490032576 | 2261898672 | 18 | 1848594 | 102699.6667 | 0 | 0 | 0.0000 | 1848594 | |
innodb/innodb_log_file | 1314 | 7464908359920 | 228096 | 5681056392 | 331110904080 | 8 | 70656 | 8832.0000 | 822 | 1140224 | 1387.1338 | 1210880 | |
mysys/charset | 3 | 313766112 | 2335872 | 104588616 | 298498992 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 183 | 413929865712 | 0 | 2261911608 | 85127343312 | 32 | 724 | 22.6250 | 24 | 8223 | 342.6250 | 8947 | |
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 | 5 | 605343024 | 1472592 | 121068552 | 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 | 3 | 47990448 | 0 | 15996816 | 26779104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 6 | 220169136 | 0 | 36694680 | 184123104 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|