1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MySQLd permantently in "top"

Discussion in 'Plesk for Linux - 8.x and Older' started by manarak, Nov 20, 2005.

  1. manarak

    manarak Guest

    0
     
    The MySQLd (version 4) process on my server seems to be permanent, as it is always shown in "top". It consumes 270MB RAM and up to 10% CPU (nothing when there is no load). It seems to run permanently, as it has an uptime as long as the server's uptime.

    I think I didn't notice this on my previous server whch was running MySQL version 3.
    Has someone else noticed this behavior of MySQLd? Is it normal?
     
  2. ShadowMan@

    ShadowMan@ Guest

    0
     
    I would imagine that if you host sites with much database usage, it may be normal. Sites with busy forums or busy online stores can often have medium to high mysql usage at all times. I don't know if this may apply to your server.
     
  3. manarak

    manarak Guest

    0
     
    Well, the process runs even when there are no clients connected.
     
  4. ShadowMan@

    ShadowMan@ Guest

    0
     
    Yes, of course the process will be in memory, it is the daemonized version of mysql. You say it uses no CPU when there is no load, which would be normal for no usage. My earlier post was referring to the 10%.

    I guess I didn't understand your original concern when I read your post earlier.

    So the appropriate response would have been - mysqld is the daemon process of mysql which would normally be a full time running process. There are mysql server parameters which can be tuned, please see the following (mysql 4.1 documentation) link:

    http://dev.mysql.com/doc/refman/4.1/en/server-parameters.html

    You may want to check your current parameter values concerning buffers and cache settings if you are worried about it taking 270MB of ram. Hope this helps!
     
  5. pran

    pran Guest

    0
     
    How do you determine which site is using up all the MySQL resources?
     
  6. ptrost

    ptrost Guest

    0
     
    Try mytop -

    http://jeremy.zawodny.com/mysql/mytop/

    This will give you a top like view of whatevery's going on in mysql land. You'll be able to tell what user is causing threads to run as well as the database being hit.
     
  7. pran

    pran Guest

    0
     
    Thanks! Just what I needed :)
     
Loading...