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 | 3121 | 3501547004736 | 0 | 1121931096 | 266978139648 | 1326 | 26836992 | 20239.0588 | 1232 | 49037312 | 39803.0130 | 75874304 | |
innodb/innodb_temp_file | 234 | 755338755600 | 0 | 3227943312 | 37452080688 | 0 | 0 | 0.0000 | 156 | 4390912 | 28146.8718 | 4390912 | |
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 | 1746 | 8663140041072 | 222288 | 4961706552 | 615852894096 | 8 | 70656 | 8832.0000 | 1200 | 2278400 | 1898.6667 | 2349056 | |
mysys/charset | 3 | 301075632 | 2166912 | 100358544 | 288086304 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 283 | 545849058480 | 0 | 1928795088 | 37810554144 | 50 | 796 | 15.9200 | 38 | 7754 | 204.0526 | 8550 | |
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 |
|