mysqld -o max_connections=800 &

I am trying to get the max_connections upped to 800 and cannot get it just right.

I am using

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
mysqld -o max_connections=800 &
[/code]

through telnet, and it is not changing it, but I get a command not found. I was in the usr/sbin/ directory where msqld, so what am I missing?

Anyone have a few pointers, or can correct my syntax for me?


Thanks

------------------
http://www.were-here.com

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by werehere:
I am trying to get the max_connections upped to 800 and cannot get it just right.

I am using

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
mysqld -o max_connections=800 &
[/code]

through telnet, and it is not changing it, but I get a command not found. I was in the usr/sbin/ directory where msqld, so what am I missing?

Anyone have a few pointers, or can correct my syntax for me?


Thanks
[/quote]


Hi,

I had the same problem and tried to change default value for max_connections through the my.cnf file, without success.

In file /etc/rc.d/init.d/mysql try edit the line :

--user=$mysql_daemon_user --datadir=$datadir --pid-file=$pid_file --log=log_file --set-variable max_connections=800 &

Make sure you have enough memory. Each connection requires, at least, the amount indicated by sort_buffer variable(default = 2Mb - see mysqladmin variables). So, for 800 connections you need at least 800*2Mb = 1600 Mb.

I'm not sure about other memory that may be required.

You can find some more tuning info, searchinf for the word 'tuning' or even 'max_connections'in the mysql discussion forum.
Bye,

GBubani