You may be able to limit resource usage for mysql. I am not sure how to do
it in windows though.
100% for a second while it executes the query is not abnormal in my
opinion.
"Nick A. Sugiero" <[EMAIL PROTECTED]>
05/05/2004 01:12 PM
To: <[EMAIL PROTECTED]>
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
Database2: 77312 data records.
Is this excessive ?
When my .asp pages request from the database on my 2.7GHz with 2GB of RAM
it
will spike to 100% for around
1 second then go back to normal.
--Nick
----- Original Message -----
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Nick A. Sugiero" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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, 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 as it effects the performance of
the
> > server / game and I'm also worried someone could use such a thing to
cause a
> > Denial of Service attack.
>
> Make sure your queries are well optimized. If they're not, they'll
> generally result in excessive CPU utilization.
>
> Jeremy
> --
> Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
>
> [book] High Performance MySQL -- http://highperformancemysql.com/
>
--
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]
