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 | 2027 | 1699171874928 | 0 | 838269168 | 571387074192 | 1365 | 27475968 | 20128.9143 | 466 | 25051136 | 53757.8026 | 52527104 | |
sql/io_cache | 114 | 5518365072 | 0 | 48406512 | 1105146768 | 38 | 2831020 | 74500.5263 | 51 | 2831020 | 55510.1961 | 5662040 | |
sql/ERRMSG | 25 | 12589064400 | 2742432 | 503562576 | 2261898672 | 15 | 1537641 | 102509.4000 | 0 | 0 | 0.0000 | 1537641 | |
innodb/innodb_temp_file | 97 | 423124516320 | 0 | 4362108168 | 22004599584 | 0 | 0 | 0.0000 | 34 | 1409024 | 41441.8824 | 1409024 | |
innodb/innodb_log_file | 321 | 2061702654000 | 228096 | 6422749608 | 331110904080 | 8 | 70656 | 8832.0000 | 189 | 168960 | 893.9683 | 239616 | |
mysys/charset | 3 | 313766112 | 2335872 | 104588616 | 298498992 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 97 | 37858002864 | 0 | 390288624 | 17943612720 | 21 | 680 | 32.3810 | 3 | 156 | 52.0000 | 836 | |
sql/binlog_index | 38 | 60269444928 | 0 | 1586037816 | 34542932160 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 372500304 | 203280 | 74500008 | 356083728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 438409488 | 979968 | 109602240 | 349562928 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 16781952 | 752400 | 5593896 | 11857824 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 695774640 | 0 | 46384800 | 631533936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 13099680 | 0 | 13099680 | 13099680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 6 | 220169136 | 0 | 36694680 | 184123104 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|