0

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

3
  • What does "Loading up any static is lightning fast" mean? See innodb_buffer_pool_size and key_buffer_size . Apr 4, 2014 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, 2014 at 13:41
  • 1
    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, 2014 at 9:03

1 Answer 1

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.