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 | 3065 | 3945507358848 | 0 | 1287277992 | 251879416800 | 1490 | 29523968 | 19814.7436 | 1090 | 43859968 | 40238.5028 | 73383936 | |
sql/io_cache | 248 | 118995494640 | 0 | 479820528 | 99457762800 | 124 | 5712630 | 46069.5968 | 94 | 5712630 | 60772.6596 | 11425260 | |
innodb/innodb_temp_file | 232 | 768773685504 | 0 | 3313679424 | 45797898432 | 0 | 0 | 0.0000 | 154 | 4358144 | 28299.6364 | 4358144 | |
sql/ERRMSG | 70 | 47964225408 | 3081936 | 685203024 | 3373521888 | 42 | 4295551 | 102275.0238 | 0 | 0 | 0.0000 | 4295551 | |
innodb/innodb_log_file | 1095 | 6206220187728 | 231264 | 5667780888 | 76632790080 | 8 | 70656 | 8832.0000 | 637 | 503296 | 790.1036 | 573952 | |
mysys/charset | 3 | 237507600 | 2109360 | 79169112 | 223908432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 16 | 4107372720 | 748176 | 256710696 | 2540267136 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog | 329 | 90075266160 | 0 | 273784896 | 34319600304 | 78 | 908 | 11.6410 | 5 | 702 | 140.4000 | 1610 | |
myisam/dfile | 22 | 2567777520 | 326304 | 116717040 | 840070176 | 5 | 684 | 136.8000 | 0 | 0 | 0.0000 | 684 | |
sql/binlog_index | 38 | 49527827184 | 0 | 1303363776 | 29235324624 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 4715480352 | 583968 | 589434912 | 2288548944 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 497655312 | 97680 | 99530904 | 467324352 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 50563920 | 2946768 | 16854552 | 37407216 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 840492048 | 0 | 56032680 | 762506976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 24433200 | 0 | 12216600 | 12694176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 45 | 3075678144 | 0 | 68348280 | 2702957664 | 17 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|