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 | 1464 | 696080077440 | 0 | 475464528 | 258817930272 | 1129 | 23609344 | 20911.7307 | 173 | 15613952 | 90254.0578 | 39223296 | |
sql/ERRMSG | 45 | 22818945600 | 3548688 | 507087504 | 1819900896 | 27 | 2754533 | 102019.7407 | 0 | 0 | 0.0000 | 2754533 | |
innodb/innodb_temp_file | 102 | 423203915376 | 0 | 4149057792 | 22296917808 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | 1540096 | |
innodb/innodb_log_file | 64 | 365505759696 | 240768 | 5711027256 | 112308358272 | 8 | 70656 | 8832.0000 | 31 | 59392 | 1915.8710 | 130048 | |
mysys/charset | 3 | 281665824 | 3494304 | 93888432 | 260379504 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 105 | 54500203824 | 0 | 519049344 | 28272112176 | 23 | 688 | 29.9130 | 3 | 156 | 52.0000 | 844 | |
sql/binlog_index | 38 | 50891884032 | 0 | 1339259856 | 31322152752 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 685519824 | 208560 | 137103912 | 661610400 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47322528 | 2762496 | 15774000 | 36416688 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 862811664 | 0 | 57520584 | 766803840 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 2930928 | 0 | 2930928 | 2930928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|