|
Put this:
set-variable = max_connections = some number
in your /etc/my.cnf file. Where some number = 1000 or 2000 or 3000, etc... See what works. Consider checking in your operating systems share/mysql directory (/usr/share/mysql, /usr/local/share/mysql) and look at the different sample configs you can use as your /etc/my.cnf. More memory usage = less disk usage = happy MySQL (In most cases anyway)
You'll have to restart MySQL for the changes to take effect.
Apparently the board didn't like my choice in braces...
|