Forum Moderators: open
I am (as an amateur) running two .asp sites on my own Win 2003 server, typically used by people in the educational system (biological photos, primarily); they have medium load, ca. 25.000 page views/day. Both are driven by a MySql database, that has been running perfectly, contrary to the Access base I started with.
Recently (the past few days), periodically it has not been possible to contact the sites, and when I check the Task manager on the server, mysqld-nt.exe is using 99% of the CPU. It takes some time, and typically it is over in 5-10 minutes.
How can I see which queries blocks the database, so I may track down what sets off the overload?
Both sites have possibilities for free text search, so maybe someone is sending to many searches for MySql to handle, or even trying to provoke errors.
I am running the log analyzer WhosOn on the server, that may help to identify the problem.
I have to add, that I am not an experienced database or webserver manager.
Sincerely Niels, from Denmark
