#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    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
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    10
    Rep Power
    0
    <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

Similar Threads

  1. I canīt make mysqld shutdown properly....
    By acpa in forum MySQL Help
    Replies: 0
    Last Post: September 16th, 2003, 09:30 AM
  2. options to mysqld
    By christo in forum MySQL Help
    Replies: 1
    Last Post: January 10th, 2003, 11:18 AM
  3. Does MySQLd die or not?
    By DiPesa in forum MySQL Help
    Replies: 0
    Last Post: August 2nd, 2001, 10:52 AM
  4. Install MySql under Windows NT
    By jayman18 in forum MySQL Help
    Replies: 2
    Last Post: April 24th, 2000, 05:22 AM
  5. mysqld conflicting queries?!?
    By Shawn in forum MySQL Help
    Replies: 0
    Last Post: March 7th, 2000, 01:47 AM

IMN logo majestic logo threadwatch logo seochat tools logo