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 | 5151 | 9164814208176 | 0 | 1779229848 | 212502190560 | 1320 | 26738688 | 20256.5818 | 2735 | 97107968 | 35505.6556 | 123846656 | |
sql/ERRMSG | 80 | 54307661760 | 3113616 | 678845640 | 3433648944 | 48 | 4912441 | 102342.5208 | 0 | 0 | 0.0000 | 4912441 | |
innodb/innodb_log_file | 3512 | 18662595639072 | 226512 | 5313950664 | 879294822384 | 8 | 70656 | 8832.0000 | 2351 | 3929600 | 1671.4590 | 4000256 | |
innodb/innodb_temp_file | 154 | 779026915920 | 0 | 5058616200 | 37118155008 | 0 | 0 | 0.0000 | 72 | 3276800 | 45511.1111 | 3276800 | |
sql/io_cache | 48 | 17043643056 | 0 | 355075776 | 12299059872 | 16 | 1202146 | 75134.1250 | 22 | 1202146 | 54643.0000 | 2404292 | |
sql/binlog | 1053 | 2538620481408 | 0 | 2410845624 | 879174649584 | 216 | 1460 | 6.7593 | 91 | 29086 | 319.6264 | 30546 | |
mysys/charset | 3 | 238257888 | 1707552 | 79419120 | 224568432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 9 | 1949995344 | 0 | 216666120 | 1338788352 | 2 | 407 | 203.5000 | 0 | 0 | 0.0000 | 407 | |
sql/binlog_index | 38 | 47620747680 | 0 | 1253177376 | 31157006496 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
myisam/dfile | 13 | 8249437680 | 0 | 634572048 | 6422465808 | 2 | 78 | 39.0000 | 0 | 0 | 0.0000 | 78 | |
mysys/cnf | 5 | 1504844880 | 185856 | 300968976 | 1488329568 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 15513168 | 640464 | 5170968 | 10122816 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1357819584 | 0 | 90521112 | 1271501088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 12 | 554567904 | 0 | 46213992 | 435687120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|