Forum Moderators: open

Message Too Old, No Replies

max connections [Mysql]

         

asson

2:23 pm on Jul 25, 2007 (gmt 0)

10+ Year Member



Hi everyone,
Running my website on a dedicated server (full control).
My site is getting more visitors these days then it usually does, however I want to change the value of max_connections, but i don't see that avalible in my my.cnf file.
--
Here are a list of all avalible options,

Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf /etc/my.cnf
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaultsPrint the program argument list and exit
--no-defaultsDon't read default options from any options file
--defaults-file=#Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
Variables (--variable-name=value)
and boolean options {FALSE¦TRUE} Value (after reading options)
--------------------------------- -----------------------------
auto-rehash TRUE
character-sets-dir (No default value)
default-character-set latin1
compress FALSE
database (No default value)
delimiter ;
vertical FALSE
force FALSE
named-commands FALSE
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 0
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket (No default value)
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
table FALSE
debug-info FALSE
user (No default value)
safe-updates FALSE
i-am-a-dummy FALSE
connect_timeout 0
max_allowed_packet 16777216
net_buffer_length 16384
select_limit 1000
max_join_size 1000000
secure-auth FALSE
show-warnings FALSE

Any ideas on how to change the value of max_connections?
Regards

asson

8:21 am on Jul 26, 2007 (gmt 0)

10+ Year Member



It's solved now, thanks anyway.

coopster

3:24 pm on Jul 26, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



How? Which version are you running?
[dev.mysql.com...]