How To: Optimize MySQL response time

High loaded website can get slow to respond when a lot of different visitors visit sites querying the same mysql database server, making it slow to respond.
There is many ways you can improve mysql server response time: by modifying the cache size, stopping dns resolution ….
Let’s see how to do that.

I remember, once at work, [...]