SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jul 2013
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Tons of mysql processes, but see no queries

    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?

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,629
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Mysql -- like most server apps -- will keep a bunch of processes running to react to incoming requests so you don't need to spin one up to respond to a query.


Bookmarks

Posting Permissions

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