List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:April 6 2007 12:12pm
Subject:Re: question about "Queries per second avg"
View as plain text  
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"
>> <christophe.gregoir@stripped>
>> To: "C.R.Vegelin" <cr.vegelin@stripped>
>> Cc: <mysql@stripped>
>> 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/mysql?unsub=1
>
>
> --
> 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.

Thread
question about "Queries per second avg"C.R.Vegelin6 Apr
  • Re: question about "Queries per second avg"Christophe Gregoir6 Apr
  • Re: question about "Queries per second avg"C.R.Vegelin6 Apr
    • Re: question about "Queries per second avg"Christophe Gregoir6 Apr
      • Re: question about "Queries per second avg"Christophe Gregoir6 Apr
      • Re: question about "Queries per second avg"Mogens Melander6 Apr
    • RE: question about "Queries per second avg"Jerry Schwartz6 Apr
  • Re: question about "Queries per second avg"Micah Stevens6 Apr