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

migrated from stackoverflow.com Apr 4 '14 at 15:42

This question came from our site for professional and enthusiast programmers.

  • 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
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, privacy policy and cookie policy