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 kill particular mysql processed

Discussion in 'General Discussion' started by its_joe, Mar 30, 2007.

  1. its_joe

    its_joe Well-Known Member

    Joined:
    Feb 15, 2007
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    166
    Hello,

    On the server how we can kill particular mysql PID. For example if I run the following command I get this result:

    mysqladmin processlist
    +--------+--------------+-----------+--------------+---------+-------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+--------------+-----------+--------------+---------+-------+-------+------------------+
    | 111633 | maximum_blog | localhost | maximum_blog | Sleep | 12793 | | |
    | 113999 | maximum_blog | localhost | maximum_blog | Sleep | 11010 | | |
    | 114340 | maximum_blog | localhost | maximum_blog | Sleep | 10728 | | |

    Now I want to kill only these processes on the server. But when i check out these processes they are under mysql PID And to kill only these PID I have to kill mysql PID and restart it again.

    So is there any other method So that I can kill only the particular PID of mysql.

    Thanks for the replies.

    its_joe
     
  2. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    778
    Likes Received:
    4
    Trophy Points:
    318
    Location:
    N.W. Iowa
    at the command line prompt:
    Code:
    mysqladmin kill PID#
    
    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. its_joe

    its_joe Well-Known Member

    Joined:
    Feb 15, 2007
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    166
    thank you for your reply. It worked..
     
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