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 | 2518 | 3019917677568 | 0 | 1199331672 | 269024469648 | 1448 | 28835840 | 19914.2541 | 638 | 29376512 | 46044.6897 | 58212352 | |
sql/io_cache | 777 | 118178726688 | 0 | 152095944 | 32230736736 | 303 | 19742523 | 65156.8416 | 339 | 19725027 | 58185.9204 | 39467550 | |
innodb/innodb_temp_file | 471 | 1820483920464 | 0 | 3865146120 | 157458023184 | 0 | 0 | 0.0000 | 340 | 10878976 | 31996.9882 | 10878976 | |
sql/ERRMSG | 55 | 38441772864 | 3193344 | 698941320 | 5071116864 | 33 | 3389231 | 102703.9697 | 0 | 0 | 0.0000 | 3389231 | |
innodb/innodb_log_file | 536 | 3158491338288 | 241824 | 5892707568 | 75712846176 | 8 | 70656 | 8832.0000 | 301 | 240640 | 799.4684 | 311296 | |
mysys/charset | 3 | 252366576 | 1834272 | 84122016 | 239019264 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 749 | 204447340944 | 0 | 272960160 | 30980635488 | 180 | 1316 | 7.3111 | 11 | 2277 | 207.0000 | 3593 | |
myisam/kfile | 16 | 9773495424 | 746064 | 610843464 | 6897871728 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog_index | 38 | 44711789232 | 0 | 1176625824 | 26920753200 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 615337008 | 299904 | 123067296 | 592396992 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 23300112 | 1246080 | 7766616 | 13526304 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 777302064 | 0 | 51820032 | 703951248 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 93989280 | 0 | 23497320 | 68480016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 8 | 77865744 | 281424 | 9733152 | 30187872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|