murthy gandikota wrote:
David kerber <[EMAIL PROTECTED]> wrote:
Just a SWAG: Maybe the traffic slows down so much that the database (if
there is one) is timing out connections and dumping stuff from its
cache, so that when people do hit it, the db has to create a new
connection and read lots of stuff from disk, which was in RAM cache
during the week?
D
This seems likely as we have seen some problems with DB connections. I am not
sure how to keep the DB connections alive when there is no traffic on the
website.
What we ended up doing was extending the connection timeout setting in
the database so that it would keep it alive over a weekend. Of course,
this will use a few more resources on the DB server, but that's not
likely to be limiting.
I don't know what you could do about the cold cache issue, though; maybe
a cron job to periodically run some typical queries against the
database? Actually, that would take care of the connection timeout
issues as well.
D
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
