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 | 2246 | 2388941235648 | 0 | 1063642536 | 469988524368 | 1383 | 27770880 | 20080.1735 | 558 | 27705344 | 49651.1541 | 55476224 | |
sql/ERRMSG | 50 | 24602615664 | 2936208 | 492052176 | 2855124624 | 30 | 3075799 | 102526.6333 | 0 | 0 | 0.0000 | 3075799 | |
innodb/innodb_temp_file | 135 | 668209657104 | 0 | 4949701152 | 35204701488 | 0 | 0 | 0.0000 | 59 | 2670592 | 45264.2712 | 2670592 | |
innodb/innodb_log_file | 365 | 3104524306224 | 228096 | 8505545928 | 607598081376 | 8 | 70656 | 8832.0000 | 214 | 227328 | 1062.2804 | 297984 | |
mysys/charset | 3 | 287348688 | 2448336 | 95782896 | 273368304 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 158 | 606218448 | 107712 | 3836712 | 480079248 | 100 | 5946 | 59.4600 | 0 | 0 | 0.0000 | 5946 | |
sql/binlog | 369 | 132861163248 | 0 | 360057192 | 20021652288 | 86 | 940 | 10.9302 | 9 | 1869 | 207.6667 | 2809 | |
myisam/kfile | 4 | 1894047408 | 679536 | 473511720 | 1871726208 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 55667774448 | 0 | 1464941280 | 30175980912 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 960594096 | 215424 | 192118608 | 937918080 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 59883648 | 3278880 | 19961040 | 38986992 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1304155776 | 0 | 86943648 | 1206314736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 570636528 | 0 | 285318264 | 557001984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|