modify max_connections

[baako]

Hi,

May I ask how do I modify the max_connections of mysql in Plesk 8?

Furthermore, any suggestion on how large should i set this value for 1G RAM? Thanks

Regards,
Baako

[baako]

No one know the answer? Baako

[Zella]

Try the following within /etc/my.cnf

[mysqld]
set-variable = max_connections=500

Change the 500 with the value you want

Then restart mysql

[baako]

Thanks a lot Zella :-)

However, I do not have the file (my.cnf) under /etc. Should I create one myself?

Just FYI

- I am using Plesk 8 under FreeBSD 6
- My other server (Redhat and FC) do have such file under /etc/, but not on my Plesk 8 FreeBSD 6 server.

Thanks.

Regards,
Baako

[Zella]

Seems not installed by default for FreeBSD OS

Then you can try to create this file with all informations you need.

Regards.

[baako]

Thanks, I will try that out :-)

[DCNet_James]

BUG: Plesk has insufficient maximum mysql connections FreeBSD

FIX: Create /usr/local/psa/mysql/var/my.cnf and increase the maximum connections in the config file. An example of my.cnf would be:

quote:
[mysqld]
set-variable = max_connections=2500

Pulled and revised from JShanley's FreeBSD Plesk Tips post, its not directly related, but solves the issue for FreeBSD.