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 | 3811 | 4612791030672 | 0 | 1210388520 | 152419135440 | 1495 | 29605888 | 19803.2696 | 1625 | 60964864 | 37516.8394 | 90570752 | |
sql/io_cache | 1069 | 454734801840 | 0 | 425383200 | 195591555984 | 468 | 25354458 | 54176.1923 | 436 | 25336962 | 58112.2982 | 50691420 | |
innodb/innodb_temp_file | 669 | 1989696591168 | 0 | 2974135296 | 470797332192 | 0 | 0 | 0.0000 | 552 | 13434880 | 24338.5507 | 13434880 | |
sql/ERRMSG | 70 | 37473216000 | 3766752 | 535331544 | 6133609680 | 42 | 4295148 | 102265.4286 | 0 | 0 | 0.0000 | 4295148 | |
innodb/innodb_log_file | 2351 | 10588478369040 | 240240 | 4503818880 | 211844238672 | 8 | 70656 | 8832.0000 | 1628 | 2512384 | 1543.2334 | 2583040 | |
mysys/charset | 3 | 483985920 | 3699696 | 161328552 | 462337392 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 795 | 581433842880 | 0 | 731363160 | 35460707568 | 176 | 1300 | 7.3864 | 42 | 8712 | 207.4286 | 10012 | |
sql/binlog_index | 38 | 51391148160 | 0 | 1352398608 | 36009178656 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1184235360 | 436128 | 236847072 | 1160427312 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1877702640 | 783024 | 469425528 | 1765071264 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 18489504 | 872256 | 6163080 | 11827200 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 987525264 | 0 | 65835000 | 887424912 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 87116304 | 0 | 14519208 | 26939088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 29142432 | 0 | 14571216 | 22681824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 32730720 | 0 | 8182680 | 14292960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 390774384 | 0 | 97693464 | 332024880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|