1. Get current DB status/parameters
2. Develop a benchmark suit before tuning
3. Set up a monitoring system to measure if my tuning improves or hurt the performance
4. Enable slow queries logging
5. Tune SQL queries of my app
6. Version control my.cnf and symbol link it.
7. Maybe, just maybe, order new hardware if necessary.
No comments:
Post a Comment