Need Someone to help me out. My Server Details : Total processors: 2 Processor #1 Intel(R) Pentium(R) Dual CPU E2160 @ 1.80GHz Processor #2 Intel(R) Pentium(R) Dual CPU E2160 @ 1.80GHz Mysql takes alot of resources over 125% Need Someone's Help Urgently!! please contact me ASAP whoever can help me out.. Waiting, Thanks
This Is the most recent top when i was getting traffic at one of my website Can someone please tell me the solution and help me out? Waiting for some urgent reply Thanks
It might be worth firing up mysql and running a "show full processlist" to see if you have queries that have been sitting there chewing away at CPU for minutes/hours on end. If you do, you can have a look what can be done to optimize the query.
When you are at your command shell, type mysql -u root -p and hit enter. This should prompt you for your password for mysql. Once into the mysql shell, type "show full processlist" and see if you have any queries that have a long time running when the load is high like this. Alternatively, you could just try restarting the mysql daemon to see if it resolves the load issue.
Restarting mysql doesnt solve the issue... can anyone solve it for me please ? waiting for someone to help...
What do you see when you do the other steps I listed for the show processlist? That might help us diagnose this.
Absolutely nothing? Are you using the root account when connecting to mysql? You might want to get someone who is a little more well versed in mysql to log into your server for you and poke around though as it doesn't sound like this is a problem that is going to be easily fixed by someone new to mysql.
Actually i dont know much about this. i manage my websites and have dedicated server.can you suggest me someone who can help me out? Waiting for your reply Thanks
You might want to create a new thread in this forum and one in the Databases/MySQL forum asking people to PM you with rates to help you out.
hi in Your Apace kindly compile with FastCGI. it will help you more. and install mysqltune.pl and run it. it will say what you need to change. thank you
Honestly, it looks like a bad MySQL configuration since there isn't much running on the machine. Unfortunately, MySQL is one of those services that you really need to monitor yourself and analyze historical usage in order to make appropriate recommendations. If you'd like, feel free to post your /etc/my.cnf contents and perhaps a few of us can give you some general tuning options which might help. An easier way to run what Iann had mentioned is 'mysqladmin pr'. You might need to run it multiple times. If at that point you are still unable to catch an queries running, this would definitely indicate an issue with your configuration.
Enable thread and query caching. Additionally, set the number of threads equal to the number of CPUs. Also, make the necessary adjustments that mysqltuner.pl recommended. It may increase your RAM usage but should decrease CPU greatly. If you need further assistance, pm me and I'll give you my default my.cnf and we can work from there.
as per the top result zombie process eating the cpu, check the top process closely as well as connection to port 80, it will help you to resolve the issue