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 | 2144 | 1880401675152 | 0 | 877052880 | 236901211536 | 1296 | 26345472 | 20328.2963 | 602 | 29016064 | 48199.4419 | 55361536 | |
innodb/innodb_temp_file | 219 | 690816763296 | 0 | 3154414296 | 32375124672 | 0 | 0 | 0.0000 | 143 | 4046848 | 28299.6364 | 4046848 | |
sql/ERRMSG | 50 | 26937208848 | 2743488 | 538744008 | 3267547008 | 30 | 3075819 | 102527.3000 | 0 | 0 | 0.0000 | 3075819 | |
sql/io_cache | 46 | 2498035584 | 0 | 54305064 | 1657734144 | 16 | 1171216 | 73201.0000 | 20 | 1171216 | 58560.8000 | 2342432 | |
innodb/innodb_log_file | 453 | 2307425624064 | 224400 | 5093654544 | 134404247472 | 8 | 70656 | 8832.0000 | 269 | 236544 | 879.3457 | 307200 | |
mysys/charset | 3 | 311093376 | 2409264 | 103697616 | 296010528 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 169 | 96366009696 | 0 | 570213072 | 18061029888 | 37 | 744 | 20.1081 | 7 | 1120 | 160.0000 | 1864 | |
sql/binlog_index | 38 | 52680074832 | 0 | 1386317592 | 33607266000 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 5654980320 | 654720 | 1130996064 | 5629308960 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 54112080 | 3019104 | 18037272 | 36891360 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 853561632 | 0 | 56903880 | 793956240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 273182448 | 0 | 68295480 | 237231456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|