Jeremy Zawodny wrote:
>
> 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.
Could you provide more details about the problems with 2.4.9's VM and
how and why you disabled swap?
>
> 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
---------------------------------------------------------------------
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