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 | 3563 | 4653354766896 | 0 | 1306021464 | 229564928208 | 1439 | 28688384 | 19936.3336 | 1535 | 58245120 | 37944.7036 | 86933504 | |
sql/io_cache | 1168 | 282690861024 | 0 | 242029656 | 85803633696 | 512 | 27755604 | 54210.1641 | 476 | 27746856 | 58291.7143 | 55502460 | |
innodb/innodb_temp_file | 790 | 1770236626752 | 0 | 2240805600 | 754181110320 | 0 | 0 | 0.0000 | 697 | 14237696 | 20427.1105 | 14237696 | |
sql/ERRMSG | 80 | 62092029648 | 3657456 | 776150232 | 4205271840 | 48 | 4903191 | 102149.8125 | 0 | 0 | 0.0000 | 4903191 | |
innodb/innodb_log_file | 1357 | 7012422665424 | 253968 | 5167592232 | 44242370832 | 8 | 70656 | 8832.0000 | 817 | 823808 | 1008.3329 | 894464 | |
mysys/charset | 3 | 354744192 | 3678576 | 118247976 | 334263072 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 461 | 625000993584 | 0 | 1355750352 | 24076751952 | 90 | 956 | 10.6222 | 47 | 11779 | 250.6170 | 12735 | |
myisam/kfile | 4 | 1859576400 | 2373360 | 464893968 | 1833631008 | 2 | 407 | 203.5000 | 0 | 0 | 0.0000 | 407 | |
sql/binlog_index | 38 | 49634521200 | 0 | 1306171416 | 30347131056 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2279847504 | 129360 | 455969448 | 2251842384 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
myisam/dfile | 5 | 1520830080 | 3219216 | 304166016 | 1477992912 | 1 | 39 | 39.0000 | 0 | 0 | 0.0000 | 39 | |
csv/metadata | 4 | 505757472 | 587664 | 126439368 | 459205296 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 15963024 | 606144 | 5320920 | 13419648 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 975764592 | 0 | 65050920 | 890469888 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 9 | 133342176 | 0 | 14815680 | 28333536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 20 | 116658432 | 0 | 5832816 | 21022320 | 8 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|