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]