Optimize SQL

Hi there,

I have a website where the server response time is ultra slow. There’s no problem with my hosting provider as they are one of the premium hosting provider and I pay 55 USD per month for its VPS hosting.

However, the server response time is 4-5 seconds. I contacted them regarding this issue, and their reply is below. They say they don’t provide any free service to fix the issue but they can tell what’s the issue.

Reply:

Throughout the course of analyzing your site and server, we were able to identify the following potential bottlenecks in your configurations.

1.
+ MySQL Server Configuration
Severity: Moderate

Issue: The current settings for MySQL server variables appear to be inappropriate for the needs of your applications. Properly optimizing MySQL server variables will not only improve the performance of database driven applications, but can also reduce the amount of CPU required by MySQL, which helps to maintain a lower load average on the server.

Solution: MySQL server variables should be appropriately adjusted in your ‘/etc/my.cnf’ file. The goal is to increase/decrease MySQL buffers as required by your applications, without causing a general memory overage on the server. Although tuning MySQL can be difficult, the following articles will guide you through the process of MySQL optimization.

http://www.mysql.com/why-mysql/performance/index.html

We would personally recommend modification of the following variables:

query_cache_size
tmp_table_size
max_heap_table_size
thread_cache_size

Could you please tell me how do I do this?

Thank You,
Vaibhav