var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Database causing load issues
We have a cpanel server with about 200 accounts on it. There seems to be a database somewhere on the server that is spiking the load. Does anybody have any suggestions on finding the database and what is causing the issues inside of th database?
watch mysqladmin processlist
As root on the server, lets you watch database queries in real time. Can be a big help. You might also want to review your MySQL configuration for further optimizations.
Is there a way to do this without root? I have a managed server and do not have root access.
If you don't have root access, better to inform your Hosting service provider to check it
Originally Posted by
mysqladmin proc stat
check who is creating this load
I don't have enough priveledges to run mysqladmin proc stat
I contacted company they seem unmotivated to assist me with this thus I'm looking for nonroot alternatives.
If you had privileges to WHM , you can see it under "Show MySQL Processes"
Can you provide a reseller account access to this plugin? I didn't think you were able. Only root has access?
If you don't have root access to your server you have extremely little control over it (if it's reasonably secure). You have to get your hosting company to provide you with root access if they won't do it themselves. This kind of issue is often an easy issue to resolve unless your server is genuinely not powerful enough to handle it.
Try using mytop (you'll need to google it as I can't post links) which is like top but for mysql.
Is the problem you don't have access to the server root account, or that you don't have access to the mysql database root account?
Without the mysql root account there is nothing you can do. If you have that, then you can use the following without server root:
mysql -u root -p -e "show processlist"
By diesel12 in forum VPS Hosting
Last Post: 01-14-2009, 01:35 AM
By Mekhu in forum Domain Names
Last Post: 07-02-2008, 04:42 PM
By sshservices in forum Hosting Security and Technology
Last Post: 03-04-2008, 02:11 PM
By THill in forum Hosting Security and Technology
Last Post: 02-23-2006, 04:59 PM
By bushtree in forum Hosting Security and Technology
Last Post: 02-13-2004, 01:05 PM