Hey David, > -----Original Message----- > From: Lopez David E-r9374c [mailto:[EMAIL PROTECTED]] > > 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.
We (a collegue actually) wrote a script that runs every 5 mins and stores the 'Questions' from MySQL. After all the servers are done (3 boxes running MySQL) it makes some nice graphs: All servers, wednesday 18 december: http://www.tweakers.net/stats?Action=Generator&Mode=Serverstats&Time=1040166 000&Tijd=00%3A00&Dagen=1&Server=&Col=SQLQueries&x=38&y=10 One server, wednesday 18 december: http://www.tweakers.net/stats?Action=Generator&Mode=Serverstats&Time=1040166 000&Tijd=00%3A00&Dagen=1&Server=Alicia&Col=SQLQueries&x=50&y=14 All servers, one week: http://www.tweakers.net/stats?Action=Generator&Mode=Serverstats&Time=1039561 200&Tijd=00%3A00&Dagen=7&Server=&Col=SQLQueries&x=52&y=8 Just play a bit with the "Grafiekgenerator" to get different graphs. note: the site is in dutch, but most english speakers shouldn't have much trouble with it, there are a lot of english terms ;)). This script was written by us, so don't expect an opensource project (the source is way too messy, and my collegue don't want to OS it, but it isn't difficult to rercreate this with mrtg / rrdtool). > > David - 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
