RE: max clients

2003-08-01 Thread Brian Austin
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. Redh

RE: max clients

2003-07-31 Thread NEWMEDIAPLAN
ginal 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 querie

Re: max clients

2003-07-31 Thread Jeremy Zawodny
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, M

Re: max clients

2003-07-31 Thread Jeremy Zawodny
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, W

Re: max clients

2003-07-31 Thread Michael Conlen
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 h

RE: max clients

2003-07-31 Thread colbey
t 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:

RE: max clients

2003-07-31 Thread NEWMEDIAPLAN
it, 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

Re: max clients

2003-07-31 Thread colbey
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 webuser

max clients

2003-07-31 Thread NEWMEDIAPLAN
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 PROTECTE

max clients

2003-07-31 Thread NEWMEDIAPLAN
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]