[Building Sakai] Mysql 5.1 and Query Cache

[Sam Ottenhoff]

The settings you added to the connection string should make this work. Can
you confirm your MySQL settings?

mysql> show variables like '%cache%';

On Wed, Aug 17, 2011 at 11:00 AM, Jennings, Michael
<mike_jennings at unc.edu>wrote:

>  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
> ****
>
> ** **
>
> 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****
>
> ** **
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110817/e0b35013/attachment.html