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

How to limit number of mysql processes

Discussion in 'Plesk for Linux - 8.x and Older' started by ranageman, Dec 13, 2007.

  1. ranageman

    ranageman Guest

    0
     
    I'm having persistent problems with running over the "numfile" limit in my VPS (its set to 2100) - MySQL likes to eat about 1600 of these, and its a lightly loaded site.

    I have tried various mysql options, reducing table_cache, max_connections etc, but cannot find the basic option to reduce the number of mysqld processes. This would at least place a limit on the open files. Right now there are 17 mysqld processes just waiting, keeping files open.

    regards,

    RM
     
  2. blank_page

    blank_page Regular Pleskian

    24
    53%
    Joined:
    Dec 17, 2006
    Messages:
    229
    Likes Received:
    0
    Hi,

    The limit of 2100 is way too low in my opinion.
     
  3. ranageman

    ranageman Guest

    0
     
    I tend to agree!

    I have now set the "flush" variable to 120, which means that every 120 seconds the files get closed (load is not too high so this is OK) but still the limit can get exceeded.

    I have also requested an increase in the limit.

    If I can't get this, how do I reduce the number of processes started by MySQL? It seems to start up with about 12 processes running by default, even before it has been accessed.
     
Loading...