rovided by Alltel
> >
> > -Original Message-
> > From: Joshua Zeidner
> >
> > Date: Wed, 8 Jul 2009 12:23:15
> > To: Main PLUG discussion list
> > Subject: Re: PHP Script timing out and MySql using almost all the CPU and
> RAM
> > qu
ua Zeidner
>
> Date: Wed, 8 Jul 2009 12:23:15
> To: Main PLUG discussion list
> Subject: Re: PHP Script timing out and MySql using almost all the CPU and RAM
> questions
>
>
> sounds like you have either a MySQl bug or a problem query. Turn on
> query logging
MySQL using 99% of CPU running a massive query doesn't sound unusual.
If that's killing your production app, look into setting up a
replication slave, and point your reporting queries at the slave.
It's not too hard to set up.
http://dev.mysql.com/doc/refman/5.0/en/replication.html
On Jul
te: Wed, 8 Jul 2009 12:23:15
> To: Main PLUG discussion list
> Subject: Re: PHP Script timing out and MySql using almost all the CPU and RAM
> questions
>
>
> sounds like you have either a MySQl bug or a problem query. Turn on
> query logging and get the query that is
: Re: PHP Script timing out and MySql using almost all the CPU and RAM
questions
sounds like you have either a MySQl bug or a problem query. Turn on
query logging and get the query that is causing the problem and post
it here.
-jmz
On Wed, Jul 8, 2009 at 12:21 PM, keith smith wrote
More RAM would certainly help as well. Its minimum requirements is 100MB,
but 1GB would probably be a good minimum, especially with the prices of
memory these days.
Eric
On Wed, Jul 8, 2009 at 12:23 PM, Joshua Zeidner wrote:
> sounds like you have either a MySQl bug or a problem query. Turn on
Thanks, I had not thought of the log. I think it is turned on already.
Thanks again!
Keith Smith
--- On Wed, 7/8/09, Joshua Zeidner wrote:
> From: Joshua Zeidner
> Subject: Re: PHP Script timing out and MySql using almost all the CPU and RAM
> quest
sounds like you have either a MySQl bug or a problem query. Turn on
query logging and get the query that is causing the problem and post
it here.
-jmz
On Wed, Jul 8, 2009 at 12:21 PM, keith smith wrote:
>
>
> Hi Everyone,
>
> I do support for an online store.
>
> Last night we were trying to
Hi Everyone,
I do support for an online store.
Last night we were trying to run a report that was taking forever. It is a lot
of data so I expected it to timeout. The owner says he has successfully run
the report before. I shelled in and found MySql was using 98.3% of the CPU and
I thin
