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 | 3016 | 4043271345696 | 0 | 1340607048 | 288632072256 | 1334 | 26968064 | 20215.9400 | 1092 | 44154880 | 40434.8718 | 71122944 | |
sql/io_cache | 234 | 198608802480 | 0 | 848755512 | 119561908224 | 82 | 5930312 | 72320.8780 | 102 | 5930312 | 58140.3137 | 11860624 | |
innodb/innodb_temp_file | 184 | 1042751146800 | 0 | 5667125640 | 38645676432 | 0 | 0 | 0.0000 | 91 | 4308992 | 47351.5604 | 4308992 | |
sql/ERRMSG | 55 | 46552188672 | 2344848 | 846403272 | 3130057392 | 33 | 3382422 | 102497.6364 | 0 | 0 | 0.0000 | 3382422 | |
innodb/innodb_log_file | 1870 | 8207593825728 | 236544 | 4389087384 | 106248683904 | 8 | 70656 | 8832.0000 | 1295 | 2330624 | 1799.7097 | 2401280 | |
mysys/charset | 3 | 200616240 | 2156352 | 66871992 | 186923088 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 377 | 559034407536 | 0 | 1482849720 | 29876077440 | 74 | 892 | 12.0541 | 37 | 7474 | 202.0000 | 8366 | |
sql/binlog_index | 38 | 46913823264 | 0 | 1234574088 | 26375902080 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 17477890320 | 665808 | 2184736224 | 16623568896 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1179698784 | 163680 | 235939704 | 1147731024 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 129918096 | 3703920 | 43306032 | 98387520 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 749776368 | 0 | 49984968 | 686632848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 425920704 | 0 | 106480176 | 321254208 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 8 | 946634832 | 0 | 118329288 | 560739168 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 597794736 | 0 | 149448552 | 540983520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 446997936 | 0 | 111749352 | 256803360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|