MySQL Max Connections Question

[miniman]

Anyone understand how to set the max_connections variable in MySQL Version 3.xx running on Win NT?

I've tried all the documented stuff, e.g. editing my.ini, using the mysqld command etc but it will not change the value.

Thanks guys!

[dontlift]

Anyone understand how to set the max_connections variable in MySQL Version 3.xx running on Win NT?

I've tried all the documented stuff, e.g. editing my.ini, using the mysqld command etc but it will not change the value.

Thanks guys!

Not tried it on windows - only Linux, but will have a look at it on our 2000 box later and get back to you

[PetrolTed]

What is the default setting for max connections?

[rsvnigel]

You want to create a file (or rename on of the existing ini files to) my.cnf and stick this in the root of the C: drive.

The add the line:

set-variable = max_connections=200

[miniman]

rsvnigel said: You want to create a file (or rename on of the existing ini files to) my.cnf and stick this in the root of the C: drive.

The add the line:

set-variable = max_connections=200

Didn't work. I created a new my.cnf and deleted all other my.ini variations. When loading winmysqladmin, the ini file is shown with the above setting in it, but the variables list does not show the setting I made.

Any other suggestions gratefully received.

Cheers...