http://www.mysql.com/doc/en/Linux.html
If you are using Linux, you need to read this section. You can get up to 4096 connections minus a few for the server admin threads. Did this a while back and works well. I don't know if any of these issues have been resolved in the Kernel or LinuxThreads yet. However, you can see from some MS SQL Server, and Oracle benchmarks, that you can have 20,000+ connections which sounds cool, till you read the fine print and see each query takes over 5 minutes! I don't remember where I read that, but it was posted on slashdot a while back. Hope that helps. Brian -----Original Message----- From: NEWMEDIAPLAN [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 1:46 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: max clients Hi Jeremy I'm planning to use a dual xeon 2.8Ghz and 6/8 gb ram on the database server. Redhat 9 is the o.s. Applications (perl dbi) will reside on other boxes. What hw/o.s. are you using? Can you send me your variables (max connections etc.) ... just for a check ;) Thanks!! |-----Original Message----- |From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] |Sent: Thursday, July 31, 2003 11:36 PM |To: NEWMEDIAPLAN |Cc: [EMAIL PROTECTED] |Subject: Re: max clients | | |On Thu, Jul 31, 2003 at 08:36:02PM +0200, NEWMEDIAPLAN wrote: |> Can mysql handle 5000 concurrent webusers sending queries to the |db through |> a web search engine. |> Is it possible (with a very big server/hw) ? | |What OS are you using? And how much hardare? |-- |Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! |<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ | |MySQL 4.0.13: up 21 days, processed 679,998,992 queries (359/sec. avg) | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
