On Fri, Sep 07, 2001 at 09:54:35AM +0100, [EMAIL PROTECTED] wrote:
>
>
> > About a year ago, I used mysql-super-smack and was able to hit
> > 8,000 per second on our [then new] server. The highest I've
> > recorded on an actual production application was around 5,000.
> > But I don't watch the numbers closely very often...
>
> Just out of curiosity, on what hardware? My needs are much lower
> than this, but my management may get worried about what we might,
> just possibly, need in the future. If I can explain that MySQL will
> stretch far beyond our conceivable needs, it would help pacify a
> hardware-oritented management who tend to favour software suppliers
> they hear about on the financial pages (i.e. M$ or Oracle, in this
> case).
This was Linux 2.2.x on a dual-cpu P3-850 with 1GB of RAM and 5 36GB
SCSI disks.
Most of the time, our busy hours run around 300-600 queries per
second, with non-peak times being in the 50 queries per second
ball-park.
But as each month goes by, the numbers keep increasing. Luckily,
we've got a lot of room to grow.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 1 days, processed 20,918,186 queries (202/sec. avg)
---------------------------------------------------------------------
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