How to tune MySQL server for performance
MySQL Performance site, published tips about tuning your MySQL server Performance.
From the article:
My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings.
I'm surprised how many people fail to provide any reasonable answer to this question, and how many servers are where in wild which are running with default settings.
Even though you can tune quite a lot of variables in MySQL Servers only few of them are really important for most common workload. After you get these settings right other changes will most commonly offer only incremental performance improvements.
Read more at mysqlperformanceblog...
Want to stay up to date with the latest Linux tips, news and announcements? Subscribe to our free e-mail newsletter or RSS feed to get all updates.
You can Email this page to a friend.
You may also be interested in other helpful articles:
- MySQL Performance Tuning tips and techniques
- Howto optimize Apache and PHP for performance
- How does query caching in MySQL works and how to find find out my MySQL query cache is working or not?
- Tuning MySQL server under Sun Solaris OS
- Install and configure MySQL on Windows XP or Vista or 2003 server
Discussion on This Article:
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!
A very nice article on tuning MySQL. I was looking for tips to tune the MySQL server on my new VPS and this article was a great help.