Assistance with mySQL performance issue

Status
Not open for further replies.

damn

Verified User
Joined
Nov 30, 2004
Messages
100
Hi All,

We seem to have some performance issues with one of our servers whenever MySQL is involved. Pages that are pure HTML load very quickly.

With many of our clients now running Wordpress based sites, we’ve got a few complains.

We’re not sure why there is a big wait to lookup any database info, and we have played with some MySQL memory settings and buffer sizes which have helped to an extent, but not enough.

The Operating System is a virtual guest on a 2012R2 HyperV host, however we can monitor the usage of CPU, memory and disk via the host and these aren't an issue. We've tried doubling RAM and vCPU which has no major change to our results.

We're hoping somebody who has a better understanding of mySQL, with CentOS and DirectAdmin experience would be able to help us out.

Our current timezine is GMT+11, you would be able to log in to the system anytime however outages and restarts would need to be after 10pm local time - please factor any timezone differences in to your response :)

Please contact me via PM to discuss in more detail.

DAMN
 

vlijmenlive

Verified User
Joined
Nov 13, 2013
Messages
64
Location
Belgium
Hi,

Since you tried doubling the ram didn't give you any improvement I wonder if your config is setup correctly to benefit from the upgrade at all.

How much ram is mysql service using in general?

Regards, Niels

Ps: checkout the huge my.cnf example and look into mariadb.
 

BBM

Verified User
Joined
Jun 8, 2013
Messages
329
Location
Dutch Mountains
Have you installed mysqltuner.pl to get some more info and suggestions about the my.cnf ?
I found it somewhat helpfull in tuning the MySQL setup.
 

zEitEr

Super Moderator
Joined
Apr 11, 2005
Messages
13,853
Location
GMT +7.00
It's now closed as the topic starter intended to hire somebody and was not looking for a solution on how to resolve the issue.
 
Status
Not open for further replies.
Top