I bought a service from syslint.com , which to manage my server, my server worked fine until I bought a ssd for my server and asked them to transfer mysql from SATA to SSD because of many people recommended SSD.
Now What is my problem?
my site is kind of social website, which has so many query to be run. one of the page has a so heavy processing to be run. before transferring I could see some times some cores full 100%, but now when user visits the page, one core is 100% but other core suddenly get 0% and other users face with waiting!
I asked syslint.com they asked for 200USD, but I'm not affordable to pay. So open the topic to diagnose problem with myself.
** Also add picture of output 'htop'.
this is picture of problem:
This is picture of normal:
I have a dedicate server with below specification:
CPU: Dual Xeon L5520
RAM: 36 GB DDR3
HDD: 1TB SATA , 146GB SSD
Last edited by pejman_view; 10-17-2013 at 03:27 PM.
Don't see any reason for that unless you have something in config limiting a query to 1 core maximum.
Kevin Cheri : Senior Server Administrator / Freelancer : 9+ years Exp, reach me out for any help Server Optimization Expert / Mysql Guru / Migration Specialist
Skype : lynxmaestro
Gmail : [email protected]
Definitely sounds like your issue could be solved by optimizing mysql... to bad your host is asking for $200 to do so. The db doesn't seem so heavy that it would require a dedicated mysql box. I wish I had more to offer.
I suggest you try percona mysql server. It has many tweaks and advantages over the standard mysql server. There's a lot of things you can optimize on your my.cnf, everything is documented on their page.