I rade some where that in the lateste MySQL versopn you can use 1000 to 1400 concurrent connection.Pls cross check in mysql site.
----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "mysql list" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 5:36 PM Subject: Re: MySQL on large server > On Thu, Jan 09, 2003 at 08:55:36AM +0000, mysql list wrote: > > Hi, > > > > I was wondering if anybody has built MySQL 3.23 from source that can > > handle a high number of connections & threads. I've have tried MySQL > > binaries in the past (not RPMs), but these have had stability/load > > problems. When building from source I don't have those issues, but I > > am limited by the inbuilt limits (of glibc,etc...) > > How many connections do you need? > > If memory serves, the master db behind Slashdot was handling around > 700 connections on a 4 processor P3 Xeon with 4GB RAM. But it's been > a while since I've talked with Brian about it. > > > I need to build MySQL 3.23 on a production server running RedHat > > 7.2, patched glibc (2.2.5-42) and a custom kernel (2.4.19-2 > > SMP). Hardware contains Dual Xeon 2.4GHz (hyperthreading disabled) > > and 6GB RAM. > > With that kind of RAM and horespower you should be able to go well > above 500 connections. > > I'd say more on this topic, but I've not really needed to push MySQL > in that direction. We tend to use more boxes that cost less and > replicate data. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 25 days, processed 863,460,485 queries (388/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 > --------------------------------------------------------------------- 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