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 | 3966 | 7015403620368 | 0 | 1768886328 | 224321320080 | 1366 | 27492352 | 20126.1728 | 1888 | 69320704 | 36716.4746 | 96813056 | |
sql/io_cache | 146 | 3209224128 | 0 | 21980904 | 328737552 | 40 | 3641944 | 91048.6000 | 66 | 3641944 | 55180.9697 | 7283888 | |
innodb/innodb_temp_file | 198 | 1013424519360 | 0 | 5118305544 | 144556025856 | 0 | 0 | 0.0000 | 114 | 4096000 | 35929.8246 | 4096000 | |
sql/ERRMSG | 65 | 44393085792 | 2691744 | 682970376 | 5212847376 | 39 | 4000138 | 102567.6410 | 0 | 0 | 0.0000 | 4000138 | |
innodb/innodb_log_file | 1536 | 8542613311056 | 225456 | 5561597184 | 102111000288 | 8 | 70656 | 8832.0000 | 945 | 1130496 | 1196.2921 | 1201152 | |
mysys/charset | 3 | 267145824 | 2276208 | 89048520 | 252954768 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 499 | 402953158080 | 0 | 807521352 | 36443622336 | 111 | 1040 | 9.3694 | 24 | 7465 | 311.0417 | 8505 | |
myisam/kfile | 4 | 784249488 | 1914000 | 196062240 | 723222720 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 53044937616 | 0 | 1395919272 | 29296613280 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 768505584 | 649440 | 96063000 | 450743040 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 626879088 | 132000 | 125375712 | 609175776 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 92885232 | 5470608 | 30961656 | 57602160 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1225226112 | 0 | 81681600 | 1159142688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 1276542432 | 0 | 212757072 | 1217157216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 265249776 | 0 | 66312312 | 235667520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 57062544 | 1401312 | 28531272 | 55661232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|