I have just upgraded my 12 year old server to a really fast new one. It is a dedicated server, Dell R620 1 x Intel E5-2620 (2.0GHz, 6C) CPU 32GB RAM - 4 x 250GB SSD RAID 1, in short vastly faster in every way to my old server. However I still have a rather slow response whenever I query the MySql database.

Loading up any static is lightning fast. Also when I view my other website (this server hosts two websites) that makes use of Mongodb, it is lighting fast. Currently I'm only using +- 2.5Gb or ram out of the 32Gb. Is there some setting for MySql to allow it to use more resources in order to speed up? Alternatively is there anything else I can do (just dealing with settings or MySql queries) to speed up this slow MySql server?

The MySql version is: 5.1.73. I'm running CentOs

  • What does "Loading up any static is lightning fast" mean? See innodb_buffer_pool_size and key_buffer_size . – Marcus Adams Apr 4 '14 at 13:15
  • Sorry, should have been a little more clear by that. I meant that loading pages without database calls. For example the "about-us" page is just plain static HTML – John Crawford Apr 4 '14 at 13:41
  • There are too many possible reasons for your problem. You have to reduce the problem to find your bottleneck (e.g. it could be a problem with your DNS). Try to reproduce it the problem and tell us which part of the mysql database is slow. Connection? Query? Which queries? See mysqltuner.pl for a tuning script if you want to change your settings. – Jens W. Apr 5 '14 at 9:03

I think you should change your server parameter to optimize server performance, you can go through this Percona Wizard https://tools.percona.com/wizard

Also you can refer a blog post http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ this shows what parameter to consider to get optimize server performance.

I personally recommend that you should upgrade your MySQL server to latest v5.6 GA and start using it as it has lot of optimization and InnoDB improvements.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy