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 | 2801 | 2764200691296 | 0 | 986861832 | 266978139648 | 1325 | 26820608 | 20241.9683 | 971 | 40714240 | 41930.2163 | 67534848 | |
innodb/innodb_temp_file | 210 | 606386847264 | 0 | 2887556232 | 37452080688 | 0 | 0 | 0.0000 | 140 | 3604480 | 25746.2857 | 3604480 | |
sql/io_cache | 56 | 977151648 | 0 | 17449080 | 79895904 | 20 | 1517632 | 75881.6000 | 26 | 1517632 | 58370.4615 | 3035264 | |
sql/ERRMSG | 45 | 28426505712 | 2857008 | 631699992 | 3913899264 | 27 | 2771926 | 102663.9259 | 0 | 0 | 0.0000 | 2771926 | |
innodb/innodb_log_file | 1614 | 7786386892944 | 222288 | 4824279240 | 615852894096 | 8 | 70656 | 8832.0000 | 1120 | 2178560 | 1945.1429 | 2249216 | |
mysys/charset | 3 | 301075632 | 2166912 | 100358544 | 288086304 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 191 | 516071576064 | 0 | 2701945224 | 37810554144 | 28 | 708 | 25.2857 | 36 | 7057 | 196.0278 | 7765 | |
sql/binlog_index | 38 | 52406859648 | 0 | 1379127816 | 30600616464 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1892637120 | 2098272 | 236579640 | 668041968 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 711900816 | 382800 | 142379952 | 665378208 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 55594176 | 2836944 | 18531216 | 39417840 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 788622912 | 0 | 52574808 | 724119792 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 66925056 | 0 | 16731264 | 28787616 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 590468208 | 0 | 147616920 | 480858576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 345369552 | 0 | 86342256 | 281897616 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 778643712 | 0 | 194660928 | 692359536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|