[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - Re: Mysql query cache
Hi again, The query cache finally works after I've reverted to mm.mysql-2.0.12-bin.jar. The problem was that the query cache somehow wouldn't work within transactions with mysql-connector-java-3.1.10-bin.jar. Anyone care to dig further? Here is one working combination: Jboss 3.2.2 with transactions JDBC: mm.mysql-2.0.12-bin.jar (3.1.10 doesn't work for me) MySQL: 4.1.14 (Haven't tried 5.0) Extract from http://dev.mysql.com/doc/mysql/en/query-cache-how.html ' In MySQL 4.0, the query cache is disabled within transactions (it does not return results). Beginning with MySQL 4.1.1, the query cache also works within transactions when using InnoDB tables (it uses the table version number to detect whether or not its contents are still current).' Regards, Al View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3899564#3899564 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3899564 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - Re: Mysql query cache
Hi All, I'm facing the same problem - Queries from JBoss app are not inserted into MySQL query cache - and neither MySQL 4.1.14 nor 5.0.13RC could solve it. Do EJB transactions have any impact on that behaviour? What are the params/factors that affect the use of query cache? I've got my app running on the following: JBoss 3.2.2. (Unable to upgrade right now) MySQL 4.0.20d, 4.1.14, 5.0.13RC (Tried all of them) mysql-connector-java-3.1.10-bin.jar I have switched on the query_cache as follows: query_cache_limit=2M query_cache_size=32M query_cache_type=1 It's working fine from MySQL-Front. Thanks, Al View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3899484#3899484 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3899484 --- This SF.Net email is sponsored by: Power Architecture Resource Center: Free content, downloads, discussions, and more. http://solutions.newsforge.com/ibmarch.tmpl ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
