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 | 2904 | 3849256692864 | 0 | 1325501496 | 218345865408 | 1315 | 26656768 | 20271.3065 | 1050 | 42942464 | 40897.5848 | 69599232 | |
sql/io_cache | 584 | 132432034944 | 0 | 226767024 | 51303339120 | 196 | 15023452 | 76650.2653 | 268 | 15023452 | 56057.6567 | 30046904 | |
innodb/innodb_temp_file | 815 | 1440600045984 | 0 | 1767607248 | 216941108208 | 0 | 0 | 0.0000 | 727 | 14401536 | 19809.5406 | 14401536 | |
sql/ERRMSG | 90 | 41766717696 | 3333792 | 464074512 | 5610119856 | 54 | 5512358 | 102080.7037 | 0 | 0 | 0.0000 | 5512358 | |
innodb/innodb_log_file | 937 | 4648121659632 | 245520 | 4960642104 | 145371391968 | 8 | 70656 | 8832.0000 | 581 | 675840 | 1163.2358 | 746496 | |
mysys/charset | 3 | 282199632 | 3621024 | 94066368 | 261738048 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 687 | 228646367664 | 0 | 332818464 | 28555457040 | 162 | 1244 | 7.6790 | 16 | 4382 | 273.8750 | 5626 | |
myisam/kfile | 12 | 1240628400 | 706992 | 103385568 | 553324992 | 6 | 1261 | 210.1667 | 0 | 0 | 0.0000 | 1261 | |
sql/binlog_index | 38 | 72430251168 | 0 | 1906059144 | 48184593072 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 545084496 | 218064 | 109016688 | 528822624 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13549008 | 649968 | 4516248 | 11089056 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 783524544 | 0 | 52234776 | 702127536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 49065456 | 0 | 9812880 | 12362592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 6 | 28386336 | 283008 | 4730880 | 10529376 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|