RE: max clients
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]
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]
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]
Re: max clients
On Thu, Jul 31, 2003 at 02:51:10PM -0400, [EMAIL PROTECTED] wrote: > > Hopefully jeremyz will toll in.. he's probably hit it before ;) I've been up to 2000 connections on a 1GB FreeBSD box. With some tweaking, I'm sure you could go quite a bit higher. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 21 days, processed 679,989,987 queries (359/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max clients
The answer (like most of these) is, "it depends". You really need to benchmark your application to know how often a "user" is going to actually hit your database server, and how many connections the application creates for each user. I've got a server that handles the databases for 3000 users hitting web apps on several different web servers without blinking (dual P4 Xeon, 2 GB of memory). It runs at worst 75% idle. On the other hand I've seen applications where 100 users would bring this server to it's knees if it were serving the database for it. It all depends on usage and you can't get from "users" to "database usage" directly. I would pile up some hardware your not using at the moment set things up and write some scripts to simulate actual usage of your application. Load the server with some real data, especially in terms of quantity of rows, and see what it handles. Measure performance and system usage metrics and go from there. -- Michael Conlen 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) ? Thanks. Roberto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: max clients
Hopefully jeremyz will toll in.. he's probably hit it before ;) On Thu, 31 Jul 2003, NEWMEDIAPLAN wrote: > > I was considering different boxes. But I'm courious to know if > anyone here knows the possibility we have with mysql... just to foresee the > crash. > > Just a software matter assuming we have a very big server :) > I saw max_connections and things like this. What's the real limit, tested? > > > > |-Original Message- > |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > |Sent: Thursday, July 31, 2003 8:40 PM > |To: NEWMEDIAPLAN > |Cc: [EMAIL PROTECTED] > |Subject: Re: max clients > | > | > |I'm not sure you'd want to do that way... Perhaps 5+ replicated boxes from > |a master that share the queries equally (hardware load balancer).. Might > |be cheaper in hardware than buying some heavy horsepower box.. > | > | > | > |On Thu, 31 Jul 2003, 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) ? > |> Thanks. Roberto > |> > |> > |> > |> -- > |> 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: max clients
I was considering different boxes. But I'm courious to know if anyone here knows the possibility we have with mysql... just to foresee the crash. Just a software matter assuming we have a very big server :) I saw max_connections and things like this. What's the real limit, tested? |-Original Message- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] |Sent: Thursday, July 31, 2003 8:40 PM |To: NEWMEDIAPLAN |Cc: [EMAIL PROTECTED] |Subject: Re: max clients | | |I'm not sure you'd want to do that way... Perhaps 5+ replicated boxes from |a master that share the queries equally (hardware load balancer).. Might |be cheaper in hardware than buying some heavy horsepower box.. | | | |On Thu, 31 Jul 2003, 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) ? |> Thanks. Roberto |> |> |> |> -- |> 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]
Re: max clients
I'm not sure you'd want to do that way... Perhaps 5+ replicated boxes from a master that share the queries equally (hardware load balancer).. Might be cheaper in hardware than buying some heavy horsepower box.. On Thu, 31 Jul 2003, 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) ? > Thanks. Roberto > > > > -- > 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]
max clients
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) ? Thanks. Roberto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max clients
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) ? Thanks. Roberto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
