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 | 7943 | 16054302414480 | 0 | 2021188752 | 208445228112 | 1485 | 29442048 | 19826.2949 | 4655 | 159891456 | 34348.3257 | 189333504 | |
sql/io_cache | 960 | 226258545744 | 0 | 235685736 | 115625705712 | 510 | 21912874 | 42966.4196 | 360 | 21912874 | 60869.0944 | 43825748 | |
innodb/innodb_temp_file | 606 | 1082776230096 | 0 | 1786759392 | 101454419088 | 0 | 0 | 0.0000 | 523 | 10731520 | 20519.1587 | 10731520 | |
innodb/innodb_log_file | 5907 | 30341052292848 | 241296 | 5136457128 | 487373194176 | 8 | 70656 | 8832.0000 | 3787 | 5882880 | 1553.4407 | 5953536 | |
sql/ERRMSG | 95 | 51436724592 | 3336960 | 541439184 | 3115452384 | 57 | 5827242 | 102232.3158 | 0 | 0 | 0.0000 | 5827242 | |
sql/binlog | 685 | 1826693428032 | 0 | 2666705712 | 45209465136 | 108 | 1028 | 9.5185 | 123 | 56827 | 462.0081 | 57855 | |
mysys/charset | 3 | 228115008 | 2193840 | 76038336 | 207151296 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 162 | 679499568 | 82368 | 4194432 | 327765504 | 101 | 6013 | 59.5347 | 0 | 0 | 0.0000 | 6013 | |
myisam/kfile | 8 | 1660930128 | 703824 | 207616200 | 1419599808 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 42625691328 | 0 | 1121728608 | 24759077904 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2429963712 | 748704 | 303745464 | 1138762416 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1139391792 | 185856 | 227878200 | 1122780384 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13122912 | 676368 | 4374216 | 10483968 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 729231888 | 0 | 48615336 | 655465536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 18 | 316032288 | 0 | 17557320 | 35784144 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 5157882576 | 0 | 573098064 | 3871025136 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|