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 | 4767 | 7753841768640 | 0 | 1626566304 | 280833414048 | 1668 | 32440320 | 19448.6331 | 2218 | 79839232 | 35996.0469 | 112279552 | |
sql/io_cache | 316 | 31617779952 | 0 | 100056264 | 12368778048 | 140 | 7153184 | 51094.1714 | 126 | 7135688 | 56632.4444 | 14288872 | |
innodb/innodb_temp_file | 194 | 1103084337696 | 0 | 5686001640 | 41026389360 | 0 | 0 | 0.0000 | 99 | 4571136 | 46173.0909 | 4571136 | |
sql/ERRMSG | 50 | 38026912176 | 2172720 | 760538064 | 3160834512 | 30 | 3067796 | 102259.8667 | 0 | 0 | 0.0000 | 3067796 | |
innodb/innodb_log_file | 1916 | 11977396739616 | 236016 | 6251250720 | 236695016976 | 8 | 70656 | 8832.0000 | 1155 | 1247744 | 1080.2978 | 1318400 | |
myisam/dfile | 16649 | 34653122592 | 86064 | 2081376 | 15364927248 | 14629 | 986767 | 67.4528 | 0 | 0 | 0.0000 | 986767 | |
mysys/charset | 3 | 220453200 | 2676960 | 73484400 | 207394704 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 422 | 623572940496 | 0 | 1477660800 | 24458590464 | 84 | 1079 | 12.8452 | 41 | 12052 | 293.9512 | 13131 | |
myisam/kfile | 16 | 2067857616 | 595584 | 129240936 | 666072528 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog_index | 38 | 55129757760 | 0 | 1450782960 | 31105839600 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 5245216944 | 651024 | 655651920 | 2329957344 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 640996752 | 159984 | 128199192 | 623298192 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47003088 | 2814240 | 15667608 | 37419888 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1167599664 | 0 | 77839872 | 1108615728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 61816656 | 0 | 10302600 | 15600816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 56 | 1041267744 | 0 | 18594048 | 489782304 | 22 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|