Archive for the 'MySQL' Category

wpSearch - Lucene search for WordPress

Code Fury
The author of this nice plugin for WordPress contacted me today about his Lucene based WordPress plugin, so I thought I would give it a try, as I’m obviously a big fan of Lucene and also never much cared for MySql’s search (in)capabilities.
The plugin is easy enough to install, only thing that struck me [...]

August 7th, 2008 | Posted in Indexing, Lucene, MySQL, Search, spell checking, wpSearch | No Comments

MySQL, Solr and “Communications link failure”

So, I was indexing a 10+ million records in MySQL into Solr and kept coming across the following odd MySQL exception:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
link failure
Last packet sent to the server was 4467745 ms ago
…

com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2985) at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871) at

In my code, I loop over a JDBC ResultSet and add the records to Solr per the Solr field schema, mapping [...]

July 16th, 2008 | Posted in Indexing, JDBC, Java, Lucene, MySQL, Solr, database | 4 Comments