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 | 5437 | 10805579090592 | 0 | 1987415496 | 293455665888 | 1602 | 31358976 | 19574.8914 | 2714 | 96092160 | 35406.1017 | 127451136 | |
sql/io_cache | 118 | 2442485760 | 0 | 20698920 | 220981728 | 62 | 2829064 | 45630.0645 | 46 | 2829064 | 61501.3913 | 5658128 | |
sql/ERRMSG | 80 | 52127088816 | 2557104 | 651588432 | 4418422272 | 48 | 4912111 | 102335.6458 | 0 | 0 | 0.0000 | 4912111 | |
innodb/innodb_temp_file | 218 | 1124424211680 | 0 | 5157908976 | 478346846736 | 0 | 0 | 0.0000 | 147 | 3784704 | 25746.2857 | 3784704 | |
innodb/innodb_log_file | 3577 | 19279563716160 | 252912 | 5389869408 | 275769921504 | 8 | 70656 | 8832.0000 | 2267 | 3039232 | 1340.6405 | 3109888 | |
sql/binlog | 1187 | 2491789019808 | 0 | 2099232432 | 36272093616 | 208 | 1428 | 6.8654 | 174 | 60157 | 345.7299 | 61585 | |
mysys/charset | 3 | 274623888 | 1204896 | 91541208 | 264225456 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 39 | 2395906656 | 202224 | 61433328 | 1917992736 | 26 | 1936 | 74.4615 | 0 | 0 | 0.0000 | 1936 | |
myisam/kfile | 12 | 1462064736 | 986304 | 121838640 | 550711392 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | 1296 | |
sql/binlog_index | 38 | 42213142224 | 0 | 1110872136 | 24221401776 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 15285507072 | 1949904 | 1910688384 | 10825816848 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 667676592 | 294624 | 133535160 | 637329792 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 22614240 | 1342704 | 7537992 | 15075984 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1042968960 | 0 | 69531264 | 985233216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 9 | 139334448 | 0 | 15481488 | 32025312 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 17 | 2709988512 | 0 | 159410856 | 2007973968 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|