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 | 3221 | 4002688339056 | 0 | 1242684960 | 218748299088 | 1465 | 29114368 | 19873.2887 | 1172 | 45924352 | 39184.6007 | 75038720 | |
sql/io_cache | 150 | 3060761088 | 0 | 20404824 | 491571168 | 40 | 2789120 | 69728.0000 | 60 | 2745380 | 45756.3333 | 5534500 | |
sql/ERRMSG | 60 | 54330929664 | 2572416 | 905515248 | 6159199200 | 36 | 3687708 | 102436.3333 | 0 | 0 | 0.0000 | 3687708 | |
innodb/innodb_temp_file | 105 | 479023073232 | 0 | 4562124336 | 38735426928 | 0 | 0 | 0.0000 | 40 | 1638400 | 40960.0000 | 1638400 | |
innodb/innodb_log_file | 1031 | 5543756711856 | 226512 | 5377067520 | 38512050192 | 8 | 70656 | 8832.0000 | 594 | 455680 | 767.1380 | 526336 | |
mysys/charset | 3 | 277377408 | 1949376 | 92459136 | 266080320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 164 | 1954888320 | 79200 | 11919864 | 1847676336 | 100 | 5946 | 59.4600 | 0 | 0 | 0.0000 | 5946 | |
myisam/kfile | 12 | 4338735984 | 769296 | 361561200 | 3111078960 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | 1296 | |
sql/binlog | 269 | 41548238688 | 0 | 154454256 | 19250616528 | 64 | 852 | 13.3125 | 3 | 156 | 52.0000 | 1008 | |
sql/binlog_index | 38 | 43663942608 | 0 | 1149051024 | 24890170272 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2446236144 | 621456 | 305779320 | 1948232352 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 441089616 | 156288 | 88217712 | 423359904 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 46338864 | 2683296 | 15446112 | 36406128 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1204416048 | 0 | 80294280 | 1142801088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5793744 | 0 | 5793744 | 5793744 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 49 | 252310080 | 0 | 5149056 | 20445216 | 19 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|