dude
try put it on var/my.cf
set-variable = max_connections = 1024
set-variable = max_user_connections = 128
set-variable = table_cache=1200
:wq!
i have this working with a mysql3x
should be similar to mysql4/5x
On 3/14/07, Bing Du <[EMAIL PROTECTED]> wrote:
Hi,
We're running mysql 4
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect
Correct.
But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change on
ma
On Wed, March 14, 2007 9:35, Bing Du said:
> Hi,
>
> We're running mysql 4.1.20. If I understand the manual correctly, I can
> change max_connections while mysqld is running without restart mysqld to
> make the change take effect. But what if mysqld restarts later in some
> other situations, like
I believe it would revert back to the settings in your my.cnf file. If
you want the change to be permanent, then set it there.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Bing Du wrote:
Hi,
We're running mysql 4.1.20. If I understand the manual correctly, I can
chang