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

MySQL - Too many connections

Discussion in 'Plesk for Windows - 8.x and Older' started by Xtrm2Matt, Feb 28, 2006.

  1. Xtrm2Matt

    Xtrm2Matt Guest

    0
     
    Hi there,

    Every other night for the past few nights, I've woken up to find my websites and game servers not responding due to MySQL having all it's connections used up. I've just checked the set connections (using mysqld --verbose --help) and it's set to 100.

    I've tried looking in the my.ini (found in C:\Program Files\SWsoft\Plesk\Databases\MySQL\Data and also C:\Program Files\SWsoft\Plesk\MySQL\Data) and max_connections is set to 300 in there, so obviously it doesn't read from that config.

    1 - Could someone please tell me where the my.ini that Plesk uses is?
    2 - Is MySQL limited to use so much RAM/CPU (by default)? <-- If so, how do I let it use more?
    3 - Is there any other config-related "tweaks" I could add / change to make MySQL perform better?

    Thank you.
     
  2. swarm

    swarm Guest

    0
     
    Actually Plesk 7.5.x use two MySQL instances. One of it installed at %plesk_dir%\Databases\MySQL\ and used for users databases, second installed at %plesk_dir%\MySQL\Data and used for internal Plesk needs. Config files for MySQL stored in Data folder in corresponding locations.

    Actually it's quite useful to update Plesk up to 7.5.6 version and both MySQL up to 4.1.18
    You can find details about how to update MySQL on Plesk servers in KB article at http://kb.swsoft.com/article_147_1077_en.html
     
  3. Xtrm2Matt

    Xtrm2Matt Guest

    0
     
    Hi there,

    I've updated MySQL now (as said above) for both the internal and external MySQL instance. I've checked the configs in both dirs, and double checked them, and the max_connections specified in there is 500 in one, and 800 in the other. However, mysqld --verbose --help still shows max_connections as 100 (and I've restarted MySQL numerous times).

    Is it possible that mysqld isn't showing the correct max_connections? Bare in mind it does show the dirs, etc, correctly.

    Thank you.
     
  4. Togy

    Togy Guest

    0
     
    I have same problem with plesk 7.5.4

    mysql : too many connection
    i always get this error.
     
  5. Xtrm2Matt

    Xtrm2Matt Guest

    0
     
    Hi there,

    I've found out that mysqld's reading of max_connections is infact false. If you change max_connections in the /Databases/MySQL/Data/my.ini, restart MySQL then check in phpMyAdmin (the one which comes default with Plesk), then that reads max_connections = xxx (e.g., mine is 800 now).

    Thanks for the support.

    Matt
     
Loading...