[Building Sakai] Mysql 5.1 and Query Cache

[Jennings, Michael]

Here are the values from the Mysql command

Show variables like '%cache%';

Variable_name                 Value
binlog_cache_size           1048576
binlog_stmt_cache_size               32768
have_query_cache         YES
key_cache_age_threshold          300
key_cache_block_size   1024
key_cache_division_limit             100
max_binlog_cache_size                18446744073709547520
max_binlog_stmt_cache_size    18446744073709547520
query_cache_limit          4194304
query_cache_min_res_unit        4096
query_cache_size           134217728
query_cache_type          ON
query_cache_wlock_invalidate                 OFF
table_definition_cache                 400
table_open_cache          2048
thread_cache_size          8

Also should I change useServerPrepStmts to useServerPrepareStmts?

Thanks,

Mike

==============================================================================
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

From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: Wednesday, August 17, 2011 11:05 AM
To: Jennings, Michael
Cc: sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] Mysql 5.1 and Query Cache

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<mailto: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<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<tel:%28919%29%20843-5013>
Cell: (919) 442-8337<tel:%28919%29%20442-8337>
E-mail: mike_jennings at unc.edu<mailto:mike_jennings at unc.edu>


_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto: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<mailto: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/30bae9e5/attachment.html