Which driver is the "best" for use with solr? I am currently using mysql-connector-java-5.1.12-bin.jar in my production setting. However I recently tried downgrading and did some quick indexing using mysql-connector-java-5.0.8-bin.jar and I close to a 2x improvement in speed!!! Unfortunately I kept getting the following error using the 5.0.8 version:
"Caused by: com.mysql.jdbc.CommunicationsException: The last communications with the server was 474 seconds ago, which is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem." I tried setting the autoReconnect="true" in my datasource configuration but I keep getting the same error. Any ideas? -- View this message in context: http://lucene.472066.n3.nabble.com/Recommended-MySQL-JDBC-driver-tp817458p817458.html Sent from the Solr - User mailing list archive at Nabble.com.
