From: Al Caponi (don_alcaponiyahoo.com.sg)
Date: Wed Oct 05 2005 - 07:35:24 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:markmysql.com]
Sent: Wednesday, April 27, 2005 12:33 AM
To: Rafal Kedziorski
Cc: mysqllists.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/mysql?unsub=don_alcaponiyahoo.com.sg

Send instant messages to your online friends http://asia.messenger.yahoo.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]