MySQL CPU overuse
I have a PHP script that is _VERY_ Database intensive (tosses log files into a table for easy stats generation).
When I run the tosser, MySQL is using 100% of the CPU. Is there a way to limit the CPU use of MySQL?
This is on Windows2000 Server and IIS5.
Enabling Process Throttling in IIS didn't help.
Is there a Win2k equivalent of "nice" that I can apply to MySQL?
did you use the default or specify your own. Please read the article http://www.microsoft.com/serviceprov...s_5_P44222.asp for reference.