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 | 2339 | 2135730235584 | 0 | 913095216 | 223742561856 | 1369 | 27541504 | 20117.9722 | 612 | 28950528 | 47304.7843 | 56492032 | |
sql/io_cache | 46 | 1190248224 | 0 | 25874904 | 392218464 | 16 | 1105232 | 69077.0000 | 20 | 1105232 | 55261.6000 | 2210464 | |
innodb/innodb_temp_file | 121 | 462940565472 | 0 | 3825955056 | 27102204624 | 0 | 0 | 0.0000 | 53 | 2048000 | 38641.5094 | 2048000 | |
sql/ERRMSG | 25 | 13916390400 | 3826416 | 556655616 | 3733489056 | 15 | 1538911 | 102594.0667 | 0 | 0 | 0.0000 | 1538911 | |
innodb/innodb_log_file | 465 | 2699676204720 | 242880 | 5805755208 | 273945574320 | 8 | 70656 | 8832.0000 | 267 | 223744 | 837.9925 | 294400 | |
mysys/charset | 3 | 284158512 | 3267792 | 94719504 | 261077520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 121 | 29096626416 | 0 | 240467832 | 14984282544 | 27 | 704 | 26.0741 | 3 | 156 | 52.0000 | 860 | |
myisam/kfile | 8 | 3016325664 | 868560 | 377040576 | 1809532560 | 4 | 799 | 199.7500 | 0 | 0 | 0.0000 | 799 | |
sql/binlog_index | 38 | 44604451584 | 0 | 1173801288 | 28562390736 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1029912048 | 591888 | 128738808 | 547511712 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 518780592 | 165264 | 103755960 | 500110512 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13600752 | 639936 | 4533408 | 10595376 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 826890768 | 0 | 55125840 | 754792368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5740944 | 0 | 5740944 | 5740944 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 336937392 | 0 | 84234216 | 288650736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 7 | 47361600 | 401808 | 6765792 | 14252832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|