Linux 2.4.x VM and MySQL (Re: A question about load / queries pr second)

2001-09-10 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 07:19:01AM -0700, Mike Wexler wrote: > > 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', b

RE: A question about load / queries pr second

2001-09-07 Thread Basil Hussain
Hi, > > 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

Re: A question about load / queries pr second

2001-09-07 Thread Mike Wexler
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

Re: A question about load / queries pr second

2001-09-07 Thread Mike Wexler
Terje Kristensen wrote: > > I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 > (hppa2.0w), > Apache/1.3.20. > > The load are rather high, and "Queries per second avg: 94.859" > This is an local B2B installation som we are really not getting any traffic > between 4PM and

RE: A question about load / queries pr second

2001-09-07 Thread Sinisa Milivojevic
Basil Hussain writes: > Hi, > > 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 machin

Re: A question about load / queries pr second

2001-09-07 Thread Jeremy Zawodny
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

RE: A question about load / queries pr second

2001-09-07 Thread Basil Hussain
Hi, > > > 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,

RE: A question about load / queries pr second

2001-09-07 Thread Jerome Ponsin
gure what it is ? Thanks in advance, Jerome >>> -Message d'origine- >>> De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]] >>> Envoye : vendredi 7 septembre 2001 11:05 >>> A : [EMAIL PROTECTED] >>> Cc : [EMAIL PROTECTED]; [EMAIL PRO

Re: A question about load / queries pr second

2001-09-07 Thread Vinche
Hello Terje, Friday, September 07, 2001, 12:11:30 PM, you wrote: TK> I have a HP-UX server with Perl 5.005_03, MySQL 3.23.39 for hp-hpux11.00 TK> (hppa2.0w), TK> Apache/1.3.20. TK> The load are rather high, and "Queries per second avg: 94.859" TK> This is an local B2B installation som we are re

Re: A question about load / queries pr second

2001-09-07 Thread Jeremy Zawodny
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

Re: A question about load / queries pr second

2001-09-07 Thread alec . cawley
> 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 nee

Re: A question about load / queries pr second

2001-09-07 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 10:11:30AM +0200, Terje Kristensen wrote: > > We have peeks where there is more than 1000 Queries per second. > Does anyone have any experience with a higher number of queries pr > second than this ? About a year ago, I used mysql-super-smack and was able to hit 8,000 per