Re: MySQL 100% CPU Spikes

2004-05-05 Thread Nick A. Sugiero
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]>

MySQL 100% CPU Spikes

2004-05-05 Thread Nick A. Sugiero
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