X
Xtrm2Matt
Guest
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.
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.