On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote:
>
> I'm quite surprised that this level of performance is available from
> such standard (well, not standard as in 'common', but y'know what I
> mean...) hardware. The last I heard, 1K+ queries/sec was only being
> done on extremely high-end Sun enterprise-level machines.
Yeah, they *were* almost all read queries...
> On the other hand though, it gives me some comfort that the hardware
> being used in my operation will meet any future needs. We have
> similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI
> RAID5). Maybe I should try out mysql-super-smack and see what kind
> of numbers it turns up. :-)
It would be interesting.
We've just finished some upgrades here (thus the recent low uptimes in
my signature). Brought out Linux boxes up to 2.4.9 and 2GB of RAM.
Had a lot of problems with 2.4.9's brain-dead VM subsystem, so I
disabled swap and things are A LOT better now.
We're on ReiserFS now and have software RAID running on one box to
test it out.
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 25,090,103 queries (225/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
