Basic question about mysql process running

Discussion in 'Web Hosting' started by tanyania, Jun 26, 2011.

0
  1. #1
    When I ssh into my server and run the 'top' command to see what processes are running it's showing this for mysql:


    18089 mysql 18 0 286m 188m 5056 S 0 12.3 64:59.47 mysqld


    All the other processes are only running for a few seconds here and there, why is mysql running for so long? I thought after any queries are done it's supposed to automatically close the connection?
     
    tanyania, Jun 26, 2011 IP
  2. Dominatos

    Dominatos Member

    Messages:
    229
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    40
    #2
    Try to restart mysql demon and if it will still run for so long- discover mysql more. Turn on slow queries log.
     
    Dominatos, Jun 27, 2011 IP