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 | 7270 | 20114807001168 | 0 | 2766823488 | 205328909280 | 1492 | 29556736 | 19810.1448 | 3602 | 130334720 | 36183.9867 | 159891456 | |
innodb/innodb_log_file | 7774 | 38540691347136 | 255024 | 4957639632 | 445584817920 | 8 | 70656 | 8832.0000 | 5135 | 9277440 | 1806.7069 | 9348096 | |
sql/ERRMSG | 90 | 54253504272 | 3141072 | 602816544 | 7141849440 | 54 | 5523665 | 102290.0926 | 0 | 0 | 0.0000 | 5523665 | |
innodb/innodb_temp_file | 270 | 890593247808 | 0 | 3298493352 | 47850034848 | 0 | 0 | 0.0000 | 84 | 3997696 | 47591.6190 | 3997696 | |
sql/binlog | 1220 | 2729320582560 | 0 | 2237147880 | 39122739744 | 211 | 1440 | 6.8246 | 185 | 103978 | 562.0432 | 105418 | |
sql/SDI | 18 | 748635360 | 0 | 41590824 | 137472720 | 0 | 0 | 0.0000 | 5 | 23799 | 4759.8000 | 23799 | |
mysys/charset | 3 | 276202608 | 4240368 | 92067360 | 256295952 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 56 | 2431483824 | 0 | 43419288 | 1783788336 | 8 | 1527 | 190.8750 | 26 | 1055 | 40.5769 | 2582 | |
sql/binlog_index | 38 | 48806079168 | 0 | 1284370296 | 33078501984 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1002532608 | 727056 | 125316576 | 526055376 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 985186224 | 166848 | 197037192 | 968430144 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13695792 | 633600 | 4565088 | 10902144 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 871512576 | 0 | 58100592 | 803489808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 178556928 | 0 | 29759400 | 105149088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 344209536 | 0 | 86052384 | 301961088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 28 | 5470364064 | 0 | 195370032 | 5179729104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|