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 | 2865 | 2860774392432 | 0 | 998525088 | 241436605872 | 1525 | 30097408 | 19736.0052 | 897 | 38027264 | 42393.8283 | 68124672 | |
sql/ERRMSG | 55 | 44222346960 | 3449424 | 804042624 | 3556964928 | 33 | 3382422 | 102497.6364 | 0 | 0 | 0.0000 | 3382422 | |
innodb/innodb_temp_file | 99 | 491150442288 | 0 | 4961115456 | 58372161408 | 0 | 0 | 0.0000 | 37 | 1392640 | 37638.9189 | 1392640 | |
innodb/innodb_log_file | 846 | 4941756578880 | 228624 | 5841319704 | 70557660624 | 8 | 70656 | 8832.0000 | 491 | 376832 | 767.4786 | 447488 | |
mysys/charset | 3 | 261455040 | 3266736 | 87151680 | 241227888 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 61 | 531371808 | 184272 | 8710944 | 409269168 | 50 | 3350 | 67.0000 | 0 | 0 | 0.0000 | 3350 | |
myisam/kfile | 16 | 3910970448 | 828432 | 244435488 | 1667850624 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog | 427 | 47446917936 | 0 | 111116808 | 16443649200 | 103 | 1008 | 9.7864 | 4 | 400 | 100.0000 | 1408 | |
sql/binlog_index | 38 | 59026654368 | 0 | 1553332968 | 37585876944 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1266822480 | 660528 | 158352744 | 559567536 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 2031298368 | 202752 | 406259568 | 1995702192 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 25743168 | 1256112 | 8581056 | 17955696 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1043250384 | 0 | 69550008 | 959095632 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 19860192 | 0 | 9930096 | 10661904 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 6 | 619933248 | 0 | 103322208 | 307826640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|