mysql max connections

change default max_connections

[iggy99]

hello --

we have MySQL - 4.1.12

i use phpMyadmin to check
Show MySQL system variables

i see "max connections 100"

how do i change this...

where is this setting defined - i need this set at 1000

also looking for any tweek tips that might help me run smooth - efficiently and with out the current 'too many connect' errors...

many thanks

:)

[jatar_k]

these links talk about Server System Variables [dev.mysql.com] and how to use them [dev.mysql.com]

you could also look at Tuning Server Parameters [dev.mysql.com]

[iggy99]

hello jatar_k

thank you for the speedy reply...

i do have an understanding of these system varibales...

however - i have no idea where, in what web server configuration file these system variables are defined...

this is my whole etc/my.cnf file where i expected these details...

do you have any idea where i should be looking for these settings?

thank you

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[coopster]

The server uses defaults for those not specifically overridden in your configuration file. You need to simply add the new directive to your configuration with the new value. jatar_k has provided a link to the MySQL pages describing how to do so.

[iggy99]

thank you...

i finally figured out i simply had to add the directive to the my.cnf file --

too easy this is probably why it made no sense to me :)

[coopster]

Beautiful, isn't it? Glad you got it sorted.