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]