We have our Struts v1.0 application run on Tomcat 4.1.24 with MySQL 4.0.20 DB Server. Our application has as many as 30 databases for 30 branches in the city. Each of the database has nearly 30 tables.Some tables have records exceeding 5 lacs. We are using LINUX WS 3 OS with each 4 GB RAM for both application server and data server.The Problem we face right now is when there are bulk usage of the Database from all branches at same time the server collapses.
We need to reboot again.
Can you suggest us any solution ?
try with re installing tomcat and please check the web.xml file