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 | 3464 | 5437154161824 | 0 | 1569617016 | 224321320080 | 1332 | 26935296 | 20221.6937 | 1548 | 58703872 | 37922.3979 | 85639168 | |
sql/ERRMSG | 60 | 42711709920 | 2691744 | 711861744 | 5212847376 | 36 | 3694919 | 102636.6389 | 0 | 0 | 0.0000 | 3694919 | |
innodb/innodb_temp_file | 153 | 754909260336 | 0 | 4934047272 | 41278366272 | 0 | 0 | 0.0000 | 73 | 3162112 | 43316.6027 | 3162112 | |
sql/io_cache | 36 | 707313024 | 0 | 19647408 | 60859920 | 10 | 889746 | 88974.6000 | 16 | 889746 | 55609.1250 | 1779492 | |
innodb/innodb_log_file | 1172 | 6447410836944 | 225456 | 5501203752 | 102111000288 | 8 | 70656 | 8832.0000 | 719 | 846336 | 1177.1015 | 916992 | |
mysys/charset | 3 | 267145824 | 2276208 | 89048520 | 252954768 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 351 | 298937692416 | 0 | 851674296 | 36443622336 | 77 | 904 | 11.7403 | 18 | 5485 | 304.7222 | 6389 | |
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 | 4 | 48290880 | 0 | 12072720 | 13667808 | 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 |
|