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-c
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 that
limit.
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 cannot go above
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 that's mussing
it up.