JDBC Connection Parameter (useServerPrepStmts)

[Matthew Buckett]

On: 

https://confluence.sakaiproject.org/display/DOC/Sakai+Admin+Guide+-+Database+Configuration+and+Tuning

there is a section "Query Caching" where it recommends turning off server prepared statements to improve performance. The additional parameters recommended are:

useServerPrepStmts=false&cachePrepStmts=true&prepStmtCacheSize=4096&prepStmtCacheSqlLimit=4096

does anyone still run with these? One issue with useServerPrepStmts=false is that it means that you can't upload anything into MySQL larger than max_alllowed_packet as the work we do streaming blobs fails when you don't have serverside prepared statement enabled.

http://stackoverflow.com/questions/3754238/is-there-any-way-to-insert-a-large-value-in-a-mysql-db-without-changing-max-allo

There are some references to serverside prepared statements having problems:

http://dev.mysql.com/doc/relnotes/connector-j/5.1/en/news-5-0-5.html

The MariaDB connector looks to support them:

https://mariadb.com/kb/en/mariadb/about-mariadb-connector-j/

--

  Matthew Buckett, VLE Developer, IT Services, University of Oxford