On Thu, Jan 24, 2002 at 02:07:14PM -0600, Jay Paulson wrote: > I'm trying to increase the maxium number of connections to my MySQL > database but I am not sure how to do this. I've gone to the manual > and it doesn't say too much (maybe i'm looking in the wrong spot?). > The machine I'm running is an AMD 650 with 512 Ram on RedHat 7.1 and > MySQL 3.23.41 so I found the following line in the manual: > > safe_mysqld -O key_buffer=64M -O table_cache=256 \ > -O sort_buffer=4M -O record_buffer=1M & > > However, it seems that I need to shut down the mysql db before I can > run this. This still doesn't solve the problem of the max number of > connections. I don't have a my.cnf file to change on the server so > the only thing I can think of is to tack on "-O max_connections=500" > at the end of the line above. Is this correct?
Yes, that ought to work. > What do I need to do to maximize the preformance on my machine? Well, that's whole different question! What sort of bottlenecks are you seeing? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 514,010,325 queries (266/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
