This is a MySQL question.
I would like to keep a MySQL database open for long periods of time without opening and closing it regularly (reason: it runs under Apache
Tomcat, and for each request to the
servlet, the servlet gets a request number from a MySQL database and table).
However, if left idle for a long period (i.e., no requests to the servlet for a long time), the database connection fails.
One solution is to open and close the database for each request, but I would think that would be expensive.
I'm wondering if a long idle connection failure is a common problem, and I am seeking advice on how best to use MySQL in this way.
David