[opencms-dev] SOLVED Re: Performance Tuning Questions

[Brett Sheeran]

Christian Steinert wrote:

> Try to use an even simpler test query like "SELECT 1".
<snip/>

> 1 - how is performance with testOnBorrow and "SELECT 1" as test query,
> but without eviction?

Better, but still not fast enough

<snip/>
> Also, mysql itself has a special query for connection checks.

I couldn't find this query, but am interested to know what it is.

Firstly, a *huge* thank you to Christian Steinert who has once again
taken the time to write in quite some detail. Thanks mate.

In the end, the solution was adding the following to lines to my.ini (or my.cnf)

wait_timeout=86400
interactive_timeout=86400

I had set wait_timeout=500 (seconds) as described on this tuning example:
http://www.opencms-wiki.org/Performance_Tuning_Example

It seems that after 500 seconds of inactivity, MySQL would drop the
connection, unknown to OpenCMS. I have since set the timeout to 24
hours and no more SQL errors

Cheers

Brett