r the tool monitoring it
"Scott Pippin" <[EMAIL PROTECTED]>
05/05/2004 02:52 PM
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject:Re: MySQL 100% CPU Spikes
>Any information on how I can go about doing this, or maybe s
>Any information on how I can go about doing this, or maybe some
>documentation on improving the speed.
>The problem is two of the databases I think, both are around 1.1MB
each and:
Try putting an explain before your select statement:
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
this will sho
Nick A. Sugiero wrote:
Jeremy,
Any information on how I can go about doing this, or maybe some
documentation on improving the speed.
The problem is two of the databases I think, both are around 1.1MB each and:
Database1: 13736 data records
Database2: 77312 data records.
Is this excessive ?
Nick:
TECTED]>
cc:
Subject: Re: MySQL 100% CPU Spikes
Jeremy,
Any information on how I can go about doing this, or maybe some
documentation on improving the speed.
The problem is two of the databases I think, both are around 1.1MB each
and:
Database1: 13736 data records
Databas
Sent: Wednesday, May 05, 2004 6:07 PM
Subject: Re: MySQL 100% CPU Spikes
> On Wed, May 05, 2004 at 03:25:14PM +0100, Nick A. Sugiero wrote:
> > Hi,
> >
> > I recently installed MySQL on a Windows 2003 Server last night to pull
some
> > stats from a online game I run,
On Wed, May 05, 2004 at 03:25:14PM +0100, Nick A. Sugiero wrote:
> Hi,
>
> I recently installed MySQL on a Windows 2003 Server last night to pull some
> stats from a online game I run, however everytime a query is sent to the
> database it uses 100% cpu causing a 100% cpu spike for a breif second
Hi,
I recently installed MySQL on a Windows 2003 Server last night to pull some
stats from a online game I run, however everytime a query is sent to the
database it uses 100% cpu causing a 100% cpu spike for a breif second - I'm
using .asp pages if that helps.
Is there anyway to avoid this at all
