gretchenl wrote:
>
> How many people have had to increase there max number of connections for MySQL? I
> have a pretty nice web server. Dual Pentium III 600's, 512 megs of ram. etc etc. What
> are some suggested performance tuning options that will help MySQL? I am pretty concerned
> with here people about raising the connections. Also, is there a way of increasing the
> amount of connections without using a my.cnf or my.ini? Are the options in the
> example.cnf the same as the default variables of MySQL when used with out the cnf?
>
> gl
put
set-variable = max_connections=2000
in /etc/my.cnf
The only reason for this limit is to keep mysqld from taking your system down my
running it out of resources. The more resources you have, the higher you should
set it.
--
Sasha Pachev
+------------------------------------------------------------------+
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
