Hi,
I solved it, so no need to answer ;-)
Be aware when changing the mysql-connector to the 3.1.x line. This
driver changes the standard behaviour of the server side cached
statements. This in turn disables the query cache.
If you change to this connector and want to use the query cache use this
flag in the connection string to disable server side prepared statements:
jdbc:mysql://....&useServerPrepStmts=false;
Tino
Tino Schöllhorn wrote:
Hi,
probable this isn't the correct forum - but nevertheless I hope that
some can help me out.
We are using OJB 1.0.1 (we're waiting for a new release to change to)
and MySQL 5.0.18. Everything is working fine and OJB works like a charm.
Now our sites are getting more traffic and we wanted to optimize MySQL.
We noticed that MySQL is not using the Query Cache for request of OJB at
all - although it is configured properly.
Are there any issues known that affect the query cache of MySQL and OJB?
Does anyone know where a *good* source for information for this issue
is? The documentation of MySQL isn't very verbose about that.
Hope someone can give me a hint.
Tino
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
