Find the answer to your Linux question:
Results 1 to 2 of 2
Hello, when i run htop command i see alot of mysql processes like this: But when i run command "mysqladmin processlist" i see usually nothing.. [root@* ~]# mysqladmin processlist +--------+------+-----------+-----+---------+------+-------+------------------+ ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux User postcd's Avatar
    Join Date
    Apr 2011
    Posts
    315

    Tons of mysql processes how to find the table and mysql commands used?


    Hello,

    when i run htop command i see alot of mysql processes like this:



    But when i run command "mysqladmin processlist" i see usually nothing..

    [root@* ~]# mysqladmin processlist
    +--------+------+-----------+-----+---------+------+-------+------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +--------+------+-----------+-----+---------+------+-------+------------------+
    | 455317 | hqs | localhost | hqs | Sleep | 3 | | |
    | 455320 | hqs | localhost | hqs | Sleep | 0 | | |
    | 455321 | root | localhost | | Query | 0 | | show processlist |
    +--------+------+-----------+-----+---------+------+-------+------------------+
    so i want to ask how can i track what are these mysql processes that i see in htop, so i see which db and which table is used?
    "Avoid the Gates of Hell. Use Linux affordable VPS."

  2. #2
    Linux Engineer
    Join Date
    Apr 2012
    Location
    Virginia, USA
    Posts
    888
    Here's a brief discussion that I believe applies to your situation:

    Too many MySQL processes - Server Fault

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •