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.

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:
    0
    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:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    at the command line prompt:
    Code:
    mysqladmin kill PID#
    
    Mickalo
     
  3. its_joe

    its_joe Well-Known Member

    Joined:
    Feb 15, 2007
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    0
    thank you for your reply. It worked..
     
Loading...

Share This Page