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 | 3851 | 3850382140176 | 0 | 999839544 | 230358733440 | 1383 | 27770880 | 20080.1735 | 2010 | 73515008 | 36574.6308 | 101285888 | |
sql/io_cache | 978 | 189815157840 | 0 | 194084880 | 127129271280 | 432 | 23317422 | 53975.5139 | 396 | 23317422 | 58882.3788 | 46634844 | |
innodb/innodb_temp_file | 1181 | 1521325097424 | 0 | 1288166880 | 58998639216 | 0 | 0 | 0.0000 | 1062 | 21921792 | 20641.9887 | 21921792 | |
sql/ERRMSG | 30 | 24198249504 | 3315312 | 806608176 | 4023741744 | 18 | 1842241 | 102346.7222 | 0 | 0 | 0.0000 | 1842241 | |
innodb/innodb_log_file | 1604 | 8219951258112 | 229152 | 5124657648 | 37966513200 | 8 | 70656 | 8832.0000 | 949 | 738816 | 778.5205 | 809472 | |
mysys/charset | 3 | 247294080 | 3451536 | 82431360 | 227166192 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 229 | 64559621808 | 0 | 281919528 | 17455792464 | 53 | 808 | 15.2453 | 5 | 591 | 118.2000 | 1399 | |
sql/binlog_index | 38 | 53821200048 | 0 | 1416347328 | 35815364640 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 9413016096 | 856944 | 1176626880 | 8554132224 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 859982640 | 210144 | 171996528 | 831023952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 22796928 | 1093488 | 7598976 | 18620976 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 890187408 | 0 | 59345616 | 788670960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 42854592 | 0 | 14284776 | 17484192 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 14 | 1646799264 | 0 | 117628368 | 847356576 | 4 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|