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 | 2232 | 2017860798624 | 0 | 904059288 | 206995888176 | 1352 | 27262976 | 20164.9231 | 569 | 27836416 | 48921.6450 | 55099392 | |
sql/ERRMSG | 40 | 27641239824 | 3678048 | 691030824 | 2626311600 | 24 | 2464981 | 102707.5417 | 0 | 0 | 0.0000 | 2464981 | |
innodb/innodb_temp_file | 96 | 432024376608 | 0 | 4500253824 | 43015606656 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | 1343488 | |
innodb/innodb_log_file | 389 | 2070843454944 | 237072 | 5323504824 | 63289522560 | 8 | 70656 | 8832.0000 | 232 | 215040 | 926.8966 | 285696 | |
mysys/charset | 3 | 354350304 | 3360192 | 118116768 | 332539680 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 185 | 81897686112 | 0 | 442689984 | 31986494496 | 42 | 764 | 18.1905 | 5 | 621 | 124.2000 | 1385 | |
myisam/dfile | 26 | 777867024 | 328944 | 29917800 | 410127168 | 12 | 738 | 61.5000 | 0 | 0 | 0.0000 | 738 | |
myisam/kfile | 4 | 260826192 | 553344 | 65206416 | 238662864 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 50671536432 | 0 | 1333461360 | 32887616784 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1724533008 | 412368 | 344906496 | 1698849504 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13239072 | 637296 | 4413024 | 10708896 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 787503552 | 0 | 52500096 | 717883056 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 40244160 | 0 | 20122080 | 28379472 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|