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 | 2636 | 2367435197424 | 0 | 898116384 | 204021059616 | 1434 | 28606464 | 19948.7197 | 833 | 36159488 | 43408.7491 | 64765952 | |
innodb/innodb_temp_file | 119 | 517419046320 | 0 | 4348059144 | 26667283632 | 0 | 0 | 0.0000 | 48 | 2162688 | 45056.0000 | 2162688 | |
sql/ERRMSG | 25 | 10901497728 | 3494832 | 436059888 | 2490819408 | 15 | 1544829 | 102988.6000 | 0 | 0 | 0.0000 | 1544829 | |
sql/io_cache | 30 | 512370672 | 0 | 17078952 | 39721968 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | 1106900 | |
innodb/innodb_log_file | 814 | 5002302499392 | 239712 | 6145334712 | 466196995968 | 8 | 70656 | 8832.0000 | 486 | 454656 | 935.5062 | 525312 | |
mysys/charset | 3 | 233185920 | 2714448 | 77728464 | 216497952 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 85 | 158261849856 | 0 | 1861904088 | 22907804832 | 14 | 652 | 46.5714 | 11 | 2038 | 185.2727 | 2690 | |
myisam/kfile | 17 | 103310828544 | 0 | 6077107344 | 99480483696 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | 1296 | |
sql/binlog_index | 38 | 52591469568 | 0 | 1383985944 | 35795482800 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 3717275760 | 709632 | 464659272 | 3146377344 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 532517568 | 243408 | 106503408 | 514925664 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 14502048 | 719136 | 4833840 | 10322928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 888910176 | 0 | 59260608 | 805959264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 41769024 | 0 | 13922832 | 28410624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 19 | 101384448 | 0 | 5335968 | 17170560 | 7 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 15 | 2311665312 | 0 | 154110792 | 2226854256 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|