[Building Sakai] Mysql 5.1 and Query Cache

[Jennings, Michael]

Hi,

We currently have mysql 5.1 running with Query Cache enabled but it does not appear that the Hibernate Prepared statements are being sent to the query cache.

We are using url at javax.sql.BaseDataSource=jdbc:mysql://############:3306/sakai?useUnicode=true&characterEncoding=UTF-8&useServerPrepStmts=false&cachePrepStmts=true&prepStmtCacheSize=4096&prepStmtCacheLimit=4096<mailto:url@javax.sql.BaseDataSource=jdbc:mysql://############:3306/sakai?useUnicode=true&characterEncoding=UTF-8&useServerPrepStmts=false&cachePrepStmts=true&prepStmtCacheSize=4096&prepStmtCacheLimit=4096>

For our connection string..

This is Sakai 2.7.0....

hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

I was reading this issue https://jira.sakaiproject.org/browse/SAK-9250 and tried to change useServerPrepStmts= false to useServerPrepareStmts= false, but that did not work.

Any help would be appreciated.

Thanks,

Mike Jennings

==============================================================================
Mike Jennings
Teaching and Learning Developer
University of North Carolina at Chapel Hill

Office: (919) 843-5013
Cell: (919) 442-8337
E-mail: mike_jennings at unc.edu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110817/39b4acae/attachment.html