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 | 1862 | 1414139039510 | 0 | 759473040 | 249018427170 | 1291 | 26263552 | 20343.5724 | 346 | 20922368 | 60469.2717 | 47185920 | |
sql/io_cache | 626 | 50760256040 | 0 | 81086555 | 12069058770 | 248 | 14348334 | 57856.1855 | 258 | 14348334 | 55613.6977 | 28696668 | |
innodb/innodb_temp_file | 223 | 747924824950 | 0 | 3353922945 | 65835769490 | 0 | 0 | 0.0000 | 146 | 4161536 | 28503.6712 | 4161536 | |
sql/ERRMSG | 30 | 18576853510 | 3072410 | 619228415 | 4499770490 | 18 | 1842161 | 102342.2778 | 0 | 0 | 0.0000 | 1842161 | |
innodb/innodb_log_file | 335 | 1987813384760 | 227900 | 5933771085 | 117643509580 | 8 | 70656 | 8832.0000 | 192 | 165376 | 861.3333 | 236032 | |
mysys/charset | 3 | 224234520 | 1664730 | 74744840 | 211980390 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 95 | 47928709310 | 0 | 504512565 | 19593776170 | 20 | 676 | 33.8000 | 4 | 519 | 129.7500 | 1195 | |
myisam/kfile | 4 | 1381409490 | 2522800 | 345352240 | 1280217120 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 55831377130 | 0 | 1469246655 | 33345254750 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 427532980 | 274540 | 85506490 | 405533210 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 273760370 | 588830 | 68439960 | 176581690 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 16082850 | 975730 | 5360950 | 12478320 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 809832580 | 0 | 53988715 | 735558380 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 14894590 | 0 | 7447295 | 11691270 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 188769040 | 0 | 94384520 | 181516520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 26628260 | 1081200 | 13314130 | 25547060 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|