In that case I refer you to the archives:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:70079:hkagoolipmedibdijphh
That message mentions that in his normal operation he is handling 1631
queries per second without even phasing the machine. He also mentions that
he got the machine digesting over 6000 inserts per second in a benchmark he
ran...this with the perl+DBI scripts running those inserts on the same
machine.
Now, Wesley has a Quad Xeon 500, 512kB cache with 3GB of memory. All with
RAID, and a lot of cache.
As I said, the load MySQL can handle is almost 100% dependant on your
hardware. I'm sure the MySQL software has some kind of roof somewhere, but
where it's at I have no idea.
----- Original Message -----
From: "Florin Andrei" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 5:04 PM
Subject: Re: lots of clients
> On 03 Apr 2001 16:49:36 -0700, Eric Fitzgerald wrote:
> > Depends on your hardware...
> >
> > 500 machines of logging, how many entries per second?
>
> I'm not sure, but i believe most of those machines will not send more
> than a couple of events per second. Some of them (but not too many) will
> surely send more.
>
> > I've seen people
> > report their MySQL installs doing hundreds or thousands of queries per
> > second, and not even phasing the machine.
>
> Ok, this sounds encouraging. ;-)
>
> --
> Florin Andrei
>
>
>
---------------------------------------------------------------------
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
