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 | 2874 | 4027018818240 | 0 | 1401189504 | 209044217712 | 1374 | 27623424 | 20104.3843 | 1027 | 41959424 | 40856.3038 | 69582848 | |
innodb/innodb_temp_file | 194 | 842803961472 | 0 | 4344350208 | 31014593808 | 0 | 0 | 0.0000 | 109 | 4079616 | 37427.6697 | 4079616 | |
sql/ERRMSG | 60 | 463636818480 | 2241888 | 7727280264 | 433413862992 | 36 | 3684383 | 102343.9722 | 0 | 0 | 0.0000 | 3684383 | |
sql/io_cache | 36 | 939850560 | 0 | 26106960 | 254474352 | 10 | 885598 | 88559.8000 | 16 | 885598 | 55349.8750 | 1771196 | |
innodb/innodb_log_file | 886 | 5711153488128 | 234432 | 6445996920 | 613062793200 | 8 | 70656 | 8832.0000 | 523 | 518144 | 990.7151 | 588800 | |
mysys/charset | 3 | 241189344 | 2086128 | 80396448 | 230000496 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 510 | 365665765344 | 0 | 716991528 | 24440465808 | 114 | 1199 | 10.5175 | 25 | 6998 | 279.9200 | 8197 | |
sql/binlog_index | 38 | 55221069024 | 0 | 1453185888 | 34126458960 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2293725984 | 1807872 | 286715616 | 1357842816 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1317123984 | 375936 | 263424744 | 1286920272 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47583360 | 2569776 | 15861120 | 36895056 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 913432608 | 0 | 60895296 | 852835104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 10 | 455721024 | 0 | 45571944 | 332747184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 618028752 | 0 | 154507056 | 509947680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|