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 | 2509 | 2126274285696 | 0 | 847458744 | 218773812576 | 1364 | 27459584 | 20131.6598 | 849 | 37011456 | 43594.1767 | 64471040 | |
sql/ERRMSG | 50 | 37329614784 | 2911920 | 746592264 | 3056239824 | 30 | 3071133 | 102371.1000 | 0 | 0 | 0.0000 | 3071133 | |
innodb/innodb_temp_file | 101 | 484844491296 | 0 | 4800440304 | 25366844976 | 0 | 0 | 0.0000 | 37 | 1523712 | 41181.4054 | 1523712 | |
sql/io_cache | 30 | 2138645520 | 0 | 71288184 | 1272335856 | 8 | 557824 | 69728.0000 | 12 | 549076 | 45756.3333 | 1106900 | |
innodb/innodb_log_file | 832 | 4992827182992 | 222816 | 6000994032 | 147732816528 | 8 | 70656 | 8832.0000 | 486 | 394240 | 811.1934 | 464896 | |
mysys/charset | 3 | 226446000 | 1477344 | 75481824 | 214875408 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 16 | 6922690368 | 1400256 | 432668016 | 2677427280 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog | 157 | 81949860960 | 0 | 521973408 | 34125256176 | 35 | 736 | 21.0286 | 5 | 647 | 129.4000 | 1383 | |
sql/binlog_index | 38 | 44850772032 | 0 | 1180283280 | 26748570816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 15789134064 | 701712 | 1973641560 | 11629755984 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 749192400 | 297792 | 149838480 | 729718176 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 21082512 | 1018512 | 7027416 | 14517360 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 871554288 | 0 | 58103496 | 811791024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 72694512 | 0 | 24231504 | 33540144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 1410029280 | 0 | 352507320 | 1311851904 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 15 | 168122592 | 588720 | 11208120 | 46142448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|