After reading a blog post about MySQL Tuning scripts I thought
about the possibility of a fully Automatic MySQL Tuner.
This is how it would work:
A daemon which would connect to your database server and then
fetch status variables, just like mysqltuner and such. Then the
daemon could decide that a parameter would need to be adjusted
and then run "SET GLOBAL …" and write a /etc/mysql/autotuner.cf
file which should be included in your my.cnf.
It should have a min/max setting for each option and some
thresholds.
Why?
- Not everyone is a DBA
- It's could better than the default settings is most cases. Luckily many defaults are updated in 5.6.
- You're not using my-huge.cf, are you?
- It could help when there are changing workloads
- It might be sufficient for …