Topic: Number of conections

[NiceM]

How can i set a higher number of conections to mysql data base, as it is now there keep coming an error mesage "to many conections".

[cactus]

How can i set a higher number of conections to mysql data base, as it is now there keep coming an error mesage "to many conections".

Are you sure your applications are properly closing the connectiosn after finishing there queries. I have seen this behavior on MySQL serves with badly written application, making connections but not closing them.

AFAIK the default for MySQL on SME Server is to allow 100 (and that is a lot) connections simultaneously. I suggest you first check weather you might have an issue in your code somewhere by login in as root to a SME Server shell and after that issueng this command:

Code: [Select]

mysql -e "show processlist"
This should give you an impression of what processes are connected to you MySQL engine at that time.

To see the maximum connections setting for your setup issue the following command on the SME Server shell (as root user as well):

Code: [Select]

mysql -e "show variables like 'max_connections'"
If you really need to modify these settings you will have to know what instruction is needed from the MySQL manual as well as being able to apply those through the SME Server template system which is outlined in the SME Server Developers Guide, which you can find in the wiki.