Results 1 to 11 of 11
  1. #1
    Join Date
    Oct 2004
    Posts
    204

    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?

  2. #2
    Join Date
    May 2002
    Location
    Kingston, Ontario
    Posts
    1,573
    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.
    Upload Guardian 2 - Malicious Upload Scanner - Windows and Linux!
    Instantly scan uploaded files
    Get notified when released

  3. #3
    Join Date
    Oct 2004
    Posts
    204
    Is there a way to do this without root? I have a managed server and do not have root access.

  4. #4
    Join Date
    Apr 2009
    Location
    inside wht
    Posts
    716
    Quote Originally Posted by AustinS View Post
    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
    24x7 PRO-ACTIVE SERVER MANAGEMENT | OUTSOURCED WEB HOSTING SUPPORT
    Now Available The first Support Brand for Startup Hosting Companies

    Sales : sales @ syslint.com | Skype us : SyslintSkype | Call us : (+91)6007799

  5. #5
    Join Date
    Jul 2009
    Posts
    178
    mysqladmin proc stat

    check who is creating this load

  6. #6
    Join Date
    Oct 2004
    Posts
    204
    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.

  7. #7
    If you had privileges to WHM , you can see it under "Show MySQL Processes"
    Support Facility | 24/7 web hosting technical support services
    Technical support | Server management | Data migration

    Technical Articles

  8. #8
    Join Date
    Oct 2004
    Posts
    204
    Can you provide a reseller account access to this plugin? I didn't think you were able. Only root has access?

  9. #9
    Join Date
    Oct 2009
    Location
    UK - London
    Posts
    73
    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.

  10. #10
    Try using mytop (you'll need to google it as I can't post links) which is like top but for mysql.

  11. #11
    Join Date
    Dec 2006
    Posts
    477
    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"

Similar Threads

  1. Other Sites on VPS Causing Issues
    By diesel12 in forum VPS Hosting
    Replies: 15
    Last Post: 01-14-2009, 01:35 AM
  2. Competitor causing issues with our extensions
    By Mekhu in forum Domain Names
    Replies: 6
    Last Post: 07-02-2008, 04:42 PM
  3. Level3 causing me issues, anyone else?
    By sshservices in forum Hosting Security and Technology
    Replies: 0
    Last Post: 03-04-2008, 02:11 PM
  4. Files in /tmp causing issues
    By THill in forum Hosting Security and Technology
    Replies: 4
    Last Post: 02-23-2006, 04:59 PM
  5. What is causing this server Load?
    By bushtree in forum Hosting Security and Technology
    Replies: 2
    Last Post: 02-13-2004, 01:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •