kees How do you measure spiked queries/s?
All I see is average queries/s from the status command. I can see the calculation based on uptime in seconds and total queries in that time. But that's average. My boss wants avg and skipped on a web site. David > -----Original Message----- > From: Kees Hoekzema [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 18, 2002 1:54 PM > To: Lenz Grimmer > Cc: [EMAIL PROTECTED] > Subject: RE: 3.23.54a Instability > > > > From: Lenz Grimmer [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 18, 2002 9:43 PM > > > OK, as I already assumed, the Max binary was not linked > statically. Doh! > > Interesting, that this also causes the load to spike, even > though it's not > > statically linked against an unpatched glibc. > Maybe it is the version of glibc i'm using? it is unstable, > the load spikes > to +50 in 2 minutes. > (it is the glibc package form Slackware 8.1) > > > > Could you please give this one a try? If this one solves the > > problem, I will publish it on our download pages ASAP: > > > > > http://work.mysql.com/~lgrimmer/mysql-max-3.23.54c-pc-linux-i6 > 86.tar.gz > > Ok, this one works without the spikes, > normally the load would jump from ~1 to +50, nog it is stable > at 1 again. > And if this one works for me, it'll work for almost everyone ;) > (kinda loaded server, +1000 queries/s spikes and avg of +350 q/s) > > -kees > > > --------------------------------------------------------------------- > 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