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 | 2298 | 2434603594368 | 0 | 1059444408 | 213452401008 | 1410 | 28213248 | 20009.3957 | 574 | 27869184 | 48552.5854 | 56082432 | |
sql/io_cache | 198 | 9440902944 | 0 | 47681304 | 1751307888 | 72 | 4796408 | 66616.7778 | 86 | 4796408 | 55772.1860 | 9592816 | |
sql/ERRMSG | 70 | 95746900656 | 3183840 | 1367812776 | 36312460272 | 42 | 4304471 | 102487.4048 | 0 | 0 | 0.0000 | 4304471 | |
innodb/innodb_temp_file | 259 | 526217936112 | 0 | 2031729480 | 27530831328 | 0 | 0 | 0.0000 | 193 | 4210688 | 21817.0363 | 4210688 | |
innodb/innodb_log_file | 478 | 4306484584512 | 236544 | 9009381744 | 777980656992 | 8 | 70656 | 8832.0000 | 274 | 228864 | 835.2701 | 299520 | |
mysys/charset | 3 | 275331936 | 2090352 | 91777224 | 262958784 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 163 | 53578570320 | 0 | 328702704 | 20979488640 | 37 | 744 | 20.1081 | 4 | 451 | 112.7500 | 1195 | |
sql/binlog_index | 38 | 46944059712 | 0 | 1235369784 | 28230714864 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 640564848 | 172656 | 128112864 | 623886912 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 16392288 | 794112 | 5464008 | 13366320 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 734937984 | 0 | 48995760 | 661497936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 10514592 | 0 | 10514592 | 10514592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|