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 | 1706 | 924383560848 | 0 | 541842576 | 282734050896 | 1280 | 26083328 | 20377.6000 | 232 | 17383424 | 74928.5517 | 43466752 | |
sql/ERRMSG | 30 | 17365775856 | 3557136 | 578859072 | 4009995264 | 18 | 1843267 | 102403.7222 | 0 | 0 | 0.0000 | 1843267 | |
innodb/innodb_temp_file | 90 | 332559804192 | 0 | 3695108736 | 27460549776 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
innodb/innodb_log_file | 159 | 1014602902896 | 228624 | 6381150072 | 197186198880 | 8 | 70656 | 8832.0000 | 85 | 95744 | 1126.4000 | 166400 | |
mysys/charset | 3 | 326309808 | 3329568 | 108769848 | 303819120 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 71 | 48679075104 | 0 | 685620672 | 16405490112 | 14 | 652 | 46.5714 | 4 | 353 | 88.2500 | 1005 | |
sql/binlog_index | 38 | 61175231040 | 0 | 1609874376 | 45271717392 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 707358432 | 184272 | 141471528 | 690767088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 16185312 | 685872 | 5395104 | 9992928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1093076160 | 0 | 72871656 | 989969904 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 12853632 | 0 | 6426816 | 9421104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|