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!

How to find MYSQL Process ID?

Discussion in 'General Discussion' started by rajajagadesh, Mar 11, 2007.

  1. rajajagadesh

    rajajagadesh Registered

    Joined:
    Nov 6, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    151
    HI Guys....

    I want to view the current mysql process id that sets after, we start the service of mysql.

    For example:
    process id for httpd:

    cat /usr/local/apache/logs/httpd.pid - 12207

    like wise i want to view the mysql process id..

    I searched everything but i can't reach to view the process id of mysql.
    Please anyone can help me...
    Thanks in advance...
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 rajajagadesh, Mar 11, 2007
  2. premkumar

    premkumar Registered

    Joined:
    Nov 28, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    151
    Hi Raja,

    MySql startup process id is located in your mysql data directory with the hostname.

    For example your mysql data directory is /var/lib/mysql/ and your hostname is example.com then it located in /var/lib/mysql/ with the name of example.com.pid

    Thanks,
    Prem.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 premkumar, Mar 11, 2007
  3. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    8
    Trophy Points:
    193
    ps -ef | grep 'mysql'
     
    #3 Spiral, Mar 11, 2007
  4. rajajagadesh

    rajajagadesh Registered

    Joined:
    Nov 6, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    151
    Hi Guys,

    Thanks for your help.... It's Working....
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 rajajagadesh, Mar 11, 2007
(You must log in or sign up to post here.)
Loading...
Similar Threads - find MYSQL Process
  1. woodland

    Finding the MySQL file in a cPanel backup

    woodland, Jan 15, 2018, in forum: Data Protection
    Replies:
    3
    Views:
    1,576
    cPWilliamL
    Jan 16, 2018
  2. ccw

    How to Find the IP Blocked by the Firewall in WHM?

    ccw, Apr 20, 2019 at 5:55 AM, in forum: Security
    Replies:
    5
    Views:
    167
    cPanelLauren
    Apr 22, 2019 at 3:53 PM
  3. iLinux85

    list matching forced to fail: failed to find host name for

    iLinux85, Apr 15, 2019, in forum: E-mail Discussion
    Replies:
    1
    Views:
    201
    cPanelLauren
    Apr 16, 2019
  4. thanasis

    SOLVED How to find total disk space ?

    thanasis, Mar 22, 2019, in forum: General Discussion
    Replies:
    14
    Views:
    371
    cPanelLauren
    Mar 27, 2019
  5. RetiredAF

    Find cause of high load

    RetiredAF, Mar 19, 2019, in forum: General Discussion
    Replies:
    5
    Views:
    314
    cPanelLauren
    Mar 20, 2019

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.
    Accept Learn More...
    Dismiss Notice