Hello.
If you can just check your application with the latest release of MySQL (4.1.14 now). Turn on the general log to be sure that MySQL receives unchanged queries and no session variables has been changed. "Al Caponi" <[EMAIL PROTECTED]> wrote: > 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----- > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
