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 | 4850 | 7857048226368 | 0 | 1620009864 | 236901211536 | 1380 | 27721728 | 20088.2087 | 2469 | 86818816 | 35163.5545 | 114540544 | |
innodb/innodb_temp_file | 475 | 1753102760640 | 0 | 3690742440 | 125771655504 | 0 | 0 | 0.0000 | 351 | 10600448 | 30200.7066 | 10600448 | |
sql/io_cache | 182 | 9522053904 | 0 | 52318728 | 2852160432 | 66 | 4183304 | 63383.3939 | 76 | 4174556 | 54928.3684 | 8357860 | |
sql/ERRMSG | 75 | 39992868960 | 2743488 | 533238024 | 3267547008 | 45 | 4605060 | 102334.6667 | 0 | 0 | 0.0000 | 4605060 | |
innodb/innodb_log_file | 2929 | 14568387635472 | 224400 | 4973843424 | 134404247472 | 8 | 70656 | 8832.0000 | 1865 | 2959872 | 1587.0627 | 3030528 | |
sql/binlog | 928 | 1220858841840 | 0 | 1315580640 | 33099361152 | 189 | 1499 | 7.9312 | 84 | 22883 | 272.4167 | 24382 | |
mysys/charset | 3 | 311093376 | 2409264 | 103697616 | 296010528 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog_index | 38 | 52680074832 | 0 | 1386317592 | 33607266000 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 639301344 | 652608 | 79912536 | 210227952 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 5654980320 | 654720 | 1130996064 | 5629308960 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 54112080 | 3019104 | 18037272 | 36891360 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 853561632 | 0 | 56903880 | 793956240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 24 | 632723520 | 0 | 26363304 | 237231456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 50111952 | 0 | 12527856 | 28917504 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 227540544 | 0 | 56885136 | 200920368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 247708032 | 0 | 61927008 | 168037584 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|