Timeline for mysqltuner - Write Key buffer hit rate
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 17, 2017 at 14:42 | comment | added | Rick James | Hitting the disk is a performance issue. The hit rate indicates what percent of the time it needs to hit the disk, which is a different metric. Hence, I was trying to redirect you to a more meaningful metric. There are a about 500 metrics; Tuner lists only a few. Many metrics are presented without good clues to answer "so what?"; you hit one such metric. | |
| Aug 17, 2017 at 11:11 | comment | added | lp1051 | Thank you! Perhaps I should mention it, but I have no performance problems. The reason for my question is solely to understand what does Write Key buffer hit rate mean, why is it reported by MySQLTuner as problematic configuration and how to improve it. I couldn't find any direct explanation or examples, and so may others... | |
| Aug 16, 2017 at 14:25 | history | answered | Rick James | CC BY-SA 3.0 |