Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

lots of /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql

Discussion in 'General Discussion' started by atokatli, Sep 4, 2006.

  1. atokatli

    atokatli Member

    Joined:
    Apr 23, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    hi
    in our server
    there are lots of connections to mysql likewise below

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

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

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

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

    .......


    is this an error, there are 20 connections
    could you explain the meaning of it
     
  2. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,696
    Likes Received:
    71
    Trophy Points:
    203
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    it is your mysql server running
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. tweakservers

    tweakservers Well-Known Member

    Joined:
    Mar 30, 2006
    Messages:
    379
    Likes Received:
    0
    Trophy Points:
    166
    login to your server as root shell and execute:

    mysql
    show processlist;

    to get you an idea what are the MySQL query is running at your MySQL server.

    You may also grab mytop which is a real time monitoring MySQL query for your server.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice