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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sql/io_cache | 2627 | 410405512176 | 0 | 156225696 | 197255944512 | 1285 | 60631788 | 47184.2708 | 1017 | 60579300 | 59566.6667 | 121211088 | |
innodb/innodb_data_file | 3604 | 5366814730464 | 0 | 1489127112 | 240508788432 | 1537 | 30294016 | 19709.8347 | 1431 | 54444032 | 38046.1440 | 84738048 | |
innodb/innodb_temp_file | 1590 | 2051840408112 | 0 | 1290465528 | 275888149152 | 0 | 0 | 0.0000 | 1470 | 28672000 | 19504.7619 | 28672000 | |
sql/ERRMSG | 70 | 59320841184 | 2725008 | 847440528 | 16349165184 | 42 | 4296101 | 102288.1190 | 0 | 0 | 0.0000 | 4296101 | |
innodb/innodb_log_file | 1295 | 7484891217936 | 228624 | 5779838592 | 45643329072 | 8 | 70656 | 8832.0000 | 768 | 742912 | 967.3333 | 813568 | |
mysys/charset | 3 | 279603984 | 1966800 | 93201240 | 266722368 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 437 | 263947225872 | 0 | 603998208 | 33693563904 | 100 | 996 | 9.9600 | 15 | 4977 | 331.8000 | 5973 | |
myisam/kfile | 8 | 2062898640 | 542256 | 257862264 | 1800383904 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 46078281744 | 0 | 1212586320 | 27516535728 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
myisam/dfile | 12 | 211479312 | 248160 | 17623056 | 176870496 | 2 | 123 | 61.5000 | 0 | 0 | 0.0000 | 123 | |
csv/metadata | 8 | 1076203920 | 679536 | 134525424 | 543671040 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 779006976 | 237600 | 155801184 | 756171504 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47389056 | 2580864 | 15796176 | 36837504 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 936889008 | 0 | 62459232 | 858818400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 7 | 87270480 | 0 | 12467136 | 15989952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 10 | 310865808 | 0 | 31086528 | 240061008 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|