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
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
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
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
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
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:
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
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
