The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Question

Discussion in 'General Discussion' started by jakeruston, Jul 26, 2008.

  1. jakeruston

    jakeruston Member

    Joined:
    Jun 16, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    What does this process do;

    /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/server1.milofi.com.pid --skip-external-locking

    It seems to be using a lot of CPU, and I need to know what it does.
     
  2. jpenner

    jpenner Registered

    Joined:
    Apr 11, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    that's your mysql server running.
     
  3. niccell

    niccell Well-Known Member

    Joined:
    Aug 10, 2005
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    If it's using a lot of CPU, typically there is a large database out there that is causing the issue. Most scripts out there were not optimized for maximum performance or tuned (PHPBB, lots of JOOMLA mods, WordPress) and will do full-table scans for data, using both CPU & Memory.

    Best advice is to track down the site causing the issue (typically you'll be able to find them in the 'Apache Status') & shut them off. Look for new clients, as there are many of them out there that insist on dragging their sorry resource-intensive websites from server to server, causing havok wherever they go cuz their too cheap to purchase a VPS or Dedi.
     
  4. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Also install mytop. Very handy to watch the users and processes during a struggling period.
     
  5. forlinuxsupport

    forlinuxsupport Well-Known Member
    PartnerNOC

    Joined:
    Dec 22, 2004
    Messages:
    386
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hi

    Log into MySQL on the command line (just type "mysql")

    Then run "show full processlist;"

    That will list all the users connected and what queries they are running.

    You should hopefully show you a large query OR user making the database work hard.

    Its not necessary a bad thing that MySQL is showing up as high - it might just be working hard and doing its job.

    Cheers
    Andy
     
Loading...

Share This Page