SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 3471 | 19323698716080 | 5567184744 | 390494404608 | 1930543296 | 630121682256 | 18691646490528 | 8 | 70656 | 8832.0000 | 2192 | 3274240 | 1493.7226 | |
innodb/innodb_data_file | 5646 | 12224328395136 | 2165130528 | 224988546816 | 353992716000 | 163265883792 | 11707069795344 | 1492 | 29556736 | 19810.1448 | 2890 | 102350848 | 35415.5183 | |
sql/binlog | 754 | 1011457922640 | 1341456072 | 49323027600 | 1117762800 | 3201293040 | 1007138866800 | 154 | 1359 | 8.8247 | 67 | 23692 | 353.6119 | |
innodb/innodb_temp_file | 123 | 609377794080 | 4954290792 | 41453083056 | 0 | 3257127984 | 606120666096 | 0 | 0 | 0.0000 | 53 | 2179072 | 41114.5660 | |
sql/binlog_index | 38 | 51802032480 | 1363211256 | 32058328368 | 378331008 | 0 | 51423701472 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 46474009824 | 714984600 | 3428419104 | 26410556832 | 0 | 20063452992 | 39 | 3990836 | 102329.1282 | 0 | 0 | 0.0000 | |
sql/io_cache | 276 | 5815465920 | 21070368 | 600916800 | 467207136 | 2564185536 | 2784073248 | 86 | 5473950 | 63650.5814 | 110 | 5412714 | 49206.4909 | |
mysys/cnf | 5 | 3292047264 | 658409400 | 3275252112 | 3276422160 | 0 | 15625104 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2958093600 | 369761568 | 1569037536 | 1229999760 | 0 | 1728093840 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 2509560240 | 627389928 | 2431824912 | 2441159424 | 0 | 68400816 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 2115607296 | 528901824 | 2084164896 | 0 | 0 | 2115607296 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 879414624 | 58627536 | 812650080 | 0 | 0 | 879414624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 280023744 | 93341160 | 261075936 | 261075936 | 0 | 18947808 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46465584 | 15488352 | 36759888 | 0 | 7066752 | 39398832 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 4 | 36878160 | 9219408 | 15102384 | 0 | 0 | 36878160 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 2 | 35226048 | 17613024 | 31574928 | 0 | 0 | 35226048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|