Hi again, It seems that the problem is solved with MySQL 4.1 (and later?). See a posting from the Jboss forum: http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830750#3830750
Cheers, Al -----Original Message----- From: Al Caponi [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 8:35 PM To: mysql@lists.mysql.com Subject: RE: JBoss queries aren't cached by MySQL Hi All, I didn't see any follow-up on this thread. Hope I can get some hint :) How to get the query cache to work with Jboss? I've got my app running on the following JBoss 3.2.2. (Unable to upgrade right now) MySQL 4.0.20d 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 However, after triggering a few queries from my applications, the query cache is not used at all: SHOW STATUS LIKE 'Qcache%'; Qcache_queries_in_cache,0 Qcache_inserts,0 Qcache_hits,0 Qcache_lowmem_prunes,0 Qcache_not_cached,328 Qcache_free_memory,33545632 Qcache_free_blocks,1 Qcache_total_blocks,1 Note: Running queries from MySQL-Front hits the cache - the above counters increase. Regards, Al -----Original Message----- From: Mark Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 12:33 AM To: Rafal Kedziorski Cc: mysql@lists.mysql.com Subject: Re: JBoss queries aren't cached by MySQL -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Rafal Kedziorski wrote: > Hi, > > we have the problem, that queries generated by JBoss or our code which > runns under JBoss will be not cached by MySQL. The same query sendet from > an external application or MySQLFront will be cached by the same MySQL. > > I'm using JBoss 3.2.5 with JDBC 3.0.16 and MySQL 4.0.23a. > > Any idea why? > > > Regards, > Rafal > > Rafal, Define what you mean by "not cached by MySQL"....Do you mean the query cache? If so, what do your query cache settings look like? -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Connectivity www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCbm1JtvXNTca6JD8RAtT9AJ9k8HnIkRh+U9UE3ROf+eff5ZudRgCgxNNI KeS6Iiq5ttoKjZsaDlyXV74= =gCL+ -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Send instant messages to your online friends http://asia.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Send instant messages to your online friends http://asia.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
