Mysql SHOW FULL PROCESSLIST id keeps increasing

Discussion in 'MySQL' started by ridesign, Nov 30, 2008.

0
  1. #1
    I used the command SHOW FULL PROCESSLIST in phpmyadmin.
    and there is one row for a database which is not being used and does not even have a user assigned.

    My questions is why is that database appearing there?
    Also the ID keeps increasing for this row when I press refresh, is that normal?


    I have included a screenshot of that row.
     

    Attached Files:

    • db.gif
      db.gif
      File size:
      2.1 KB
      Views:
      121
    ridesign, Nov 30, 2008 IP
  2. pondlife

    pondlife Peon

    Messages:
    898
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Can't really tell from that image but it could be a system table - MySQL has to have several of it's own tables just to run.

    When I run the same query from myPHPAdmin I get the same response :)
     
    pondlife, Nov 30, 2008 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    Did you notice the Info column? It is showing the same query which you are running i.e. SHOW FULL PROCESSLIST. It is showing the same process which is executing this query.
     
    mwasif, Nov 30, 2008 IP
  4. ridesign

    ridesign Peon

    Messages:
    294
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    in the db column it has a specific database name which I have not allocated a username, but I have over 10 other different db's as well. Should they not appear as well?
     
    ridesign, Nov 30, 2008 IP