ncorporated
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: quest
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
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));
n 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
divi
ns:
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
07 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]
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]
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"
machine.
Victor
-Original Message-
From: Dan Johnson
To: [EMAIL PROTECTED]
Sent: 4/12/04 9:16 AM
Subject: Re: Queries per second average
Victor Pendleton wrote:
>I agree with Peter, 50 queries per second is not a MySQL limit. Have
you
>checked the slow
>query log or the *.err lo
Awesome. Hope it works out.
P
Dan Johnson <[EMAIL PROTECTED]>
04/12/2004 02:16 PM
To: [EMAIL PROTECTED]
cc:
Subject: Re: Queries per second average
Victor Pendleton wrote:
>I agree with Peter, 50 queries per second is not a MySQL limit.
Victor Pendleton wrote:
I agree with Peter, 50 queries per second is not a MySQL limit. Have you
checked the slow
query log or the *.err log file to see if anything is being logged or if
`bad-performing`
queries are causing this bottleneck? Have you checked your variables to see
what your
`max
Dan Johnson wrote:
The site that I am working on is experiencing MySQL freeze ups any
time after the 'Queries per second average'; seen on the STATUS
output; is at 48-50 in value. When the site owner asked the hosting
service about this they told him that the MySQL cannot go above t
At 08:16 AM 4/12/2004, you wrote:
The site that I am working on is experiencing MySQL freeze ups any time
after the 'Queries per second average'; seen on the STATUS output; is at
48-50 in value. When the site owner asked the hosting service about this
they told him that the MySQL
I agree with Peter, 50 queries per second is not a MySQL limit. Have you
checked the slow
query log or the *.err log file to see if anything is being logged or if
`bad-performing`
queries are causing this bottleneck? Have you checked your variables to see
what your
`max-connections` variable is
I've done hundreds if not thousands of queries per second...
I do not see how the server can be an issue unless it's configuration is
bare.. And I don't know how much
that should affect it if it's a decent server :-/ If there are
configuration constraints, it could be disk
The site that I am working on is experiencing MySQL freeze ups any time
after the 'Queries per second average'; seen on the STATUS output; is at
48-50 in value. When the site owner asked the hosting service about this
they told him that the MySQL cannot go above that limit. He still
On Wed, Nov 26, 2003 at 02:16:16PM -0800, trevor%tribenetwork.com wrote:
> Greetings,
>
> From what I can gather the" Queries per second average" quoted by
> ">status" is a pure division of "Questions" by "Uptime" in ">show
> statu
Greetings,
>From what I can gather the" Queries per second average" quoted by ">status"
is a pure division of "Questions" by "Uptime" in ">show status". Is there a
way to flush these figures periodically? I want to be able to set th
Quoting Jeremy Zawodny <[EMAIL PROTECTED]>:
> On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote:
> >
> > An example from just after restart (using myTop in 'm' mode showing
> > number of queries executed each 1 second interval):
>
> Dan has your answer on this. I'm just amazed th
On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote:
>
> An example from just after restart (using myTop in 'm' mode showing
> number of queries executed each 1 second interval):
Dan has your answer on this. I'm just amazed that anyone uses the 'm'
feature. I added it mostly as a d
In the last episode (Oct 15), Gavin Foster IFP said:
> From our calculations site usage should be generating around 6
> queries per second. This is confirmed by the frequency of queries
> appearing in the master binlog, and by increases in the 'questions'
> value of 'sh
I have two servers - one serving a live site and once acting as a backup via
replication.
>From our calculations site usage should be generating around 6 queries per second.
>This is confirmed by the frequency of queries appearing in the master binlog, and by
>increases in the &
On Wed, Sep 18, 2002 at 02:00:54PM -0600, Mike Hillyer wrote:
> Hi All;
>
> Is there any way to get a real time queries per second in MySQL as opposed
> to the average given when I request the server status?
Use mytop:
http://jeremy.zawodny.com/mysql/mytop/
That's partly w
From: Mike Hillyer
MH> > Is there any way to get a real time queries per second in MySQL as
MH> > opposed to the average given when I request the server status?
From: Dan Nelson
DN> Request status twice, with a 1-second delay in between.
I think what Mike is looking for is an a
In the last episode (Sep 18), Mike Hillyer said:
> Hi All;
>
> Is there any way to get a real time queries per second in MySQL as
> opposed to the average given when I request the server status?
Request status twice, with a 1-second delay in between.
--
Dan Nelson
At 14:00 -0600 9/18/02, Mike Hillyer wrote:
>Hi All;
>
>Is there any way to get a real time queries per second in MySQL as opposed
>to the average given when I request the server status?
"real time" defined
Hi All;
Is there any way to get a real time queries per second in MySQL as opposed
to the average given when I request the server status?
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hi
I'm trying to see how many queries per second I have running in my MySQL server.
I understand that the number i see (Queries per second avg) is the average since the
time the MySQL Server came up.
The numbers i see below do not make much sense since the number stabilizes around
47 a
---Reply to mail from Nathanial Hendler about How many queries per second do you get?
>
> Hello, I was just looking at my MySQL databse using mytop and saw that I was
> getting over 60 queries per second. Can people give me an idea of how many
> queries per second they get?
&g
Hello, I was just looking at my MySQL databse using mytop and saw that I was
getting over 60 queries per second. Can people give me an idea of how many
queries per second they get?
Thanks,
Nathan Hendler
Tucson, AZ USA
http://retards.org
30 matches
Mail list logo
