Hi, i m using mysql 4.0.15 and tomcat 4 as a webserver on linux 8 machine, now the problem that i am facing is that while testing my web application when i send too many refresh requests to the web page, the server's CPU utilization reaches to 100% for a very long duration of time and on checking the processes going on the server, i see hundreds of processes for tomcat and mysql. Now what am i suppose to do to save my server from crashing and at the same time fulfilling maximum number of requests.
I will be very thank ful to u.
This could be a Tomcat or MySQL problem, but let's make sure it is not MySQL first.
Enable log-slow-queries and log-long-format, then audit the slow log, explain all of the queries that end up there and optimize them starting at the ones that examine the most rows first. To automate the process, you might find my query-wizzard utility helpful, which you can get at http://www.wiley.com/compbooks/pachev/
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
