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]
Re: question about Queries per second avg
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]
Re: question about Queries per second avg
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]
Re: question about Queries per second avg
Ofcourse, the number of queries is just the value of Questions. 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]
Re: question about Queries per second avg
It's just telling you how many queries per second on average the server is receiving. This says nothing about how long it takes to execute a particular query. -Micah On 04/06/2007 01:22 AM, C.R.Vegelin wrote: Hi List, Using printf( System status: %s\n, mysqli_stat($link)); in a PHP script, says: Queries per second avg: 0.051. This means that a query takes about 20 seconds ? But the query result is given immediately. How should I interpret Queries per second avg ? I'm using version 5.0.15 NT. Regards, Cor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question about Queries per second avg
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]
RE: question about Queries per second avg
It says nothing about how long it takes to process a query (service time); it tells you on average how often queries come in (arrival rate). If the service time is such that an arriving query is finished before the next one arrives, you aren't in terrible shape as far as the queue of waiting queries goes. If queries arrive while the previous query is still being served, then all is lost because the queue will grow to infinity. That's a very simplistic overview, there's an entire branch of statistics devoted to this sort of thing. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: C.R.Vegelin [mailto:[EMAIL PROTECTED] Sent: Friday, April 06, 2007 4:46 AM To: Christophe Gregoir Cc: mysql@lists.mysql.com Subject: Re: question about Queries per second avg 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]