Re: mysql max_connections

[Rick James]

As of MySQL 5.0.52, values larger than 4GB are allowed for 64-bit platforms (except 64-bit Windows, for which large values are truncated to 4GB with a warning).

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_key_buffer_size
says that it is a mysqld arg, a my.cnf arg, and can be SET dynamically.

With 24GB of RAM, you can spare room for more connections. It is set in similar ways: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_connections