My idea of this is : (Questions+Slow queries)/Uptime = Queries per second avg
(118794 + 16) / 84751) = 1,4018713643496831895788840249673 Uptime: 84751 Threads: 2 Questions: 118794 Slow queries: 16 Opens: 478 Flush tables: 1 Open tables: 29 Queries per second avg: 1.402 -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 On Fri, April 6, 2007 10:16, Christophe Gregoir wrote: > I have to admit, Google doesn't provide much information. > Let's take a closer look and see if we can't figure out ourselves what > that value means. > > Here is the output of `mysqladmin status` on my development box: > Uptime: 7510 Threads: 3 Questions: 4123 Slow queries: 0 Opens: > 713 Flush tables: 1 Open tables: 64 Queries per second avg: 0.549 > > The number of queries would be Questions + Slow queries. > See if you can spot where mysqladmin gets its time count and use it to > divide the previous sum. > > Your box isn't underperforming, it just isn't under a high load. > > Question answered ? > > > grtz > > > > > C.R.Vegelin wrote: >> Thanks Christophe, >> >> Question rephrased: how do you explain 0.05 q/s = 20 s/q >> with an immediate response ? >> >> Cor >> >> ----- Original Message ----- From: "Christophe Gregoir" >> <[EMAIL PROTECTED]> >> To: "C.R.Vegelin" <[EMAIL PROTECTED]> >> Cc: <mysql@lists.mysql.com> >> Sent: Friday, April 06, 2007 8:35 AM >> Subject: Re: question about "Queries per second avg" >> >> >>> C.R.Vegelin wrote: >>>> ... >>>> How should I interpret "Queries per second avg" ? >>>> >>> >>> >>> How about as 'queries per second on average' :) >>> >> >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
