sphinx search – .pQd's log

sphinxsearch reborn as manticoresearch?

2017-07-232017-09-10 by .pQd

for the past year number of commits in my favorite open source text-search server – the sphinxsearch project – has dropped to nearly 0. looks like in the meanwhile some of the old contributors moved to another project – manticoresearch. the website of the new project features two prominent supporters – craigslist and boardreader. fingers ... Read More

sphinx search 2.2.11 – column count does not match schema (expected 3, got 2)

2016-09-07 by .pQd

i have a real-time sphinx that was configured in this way:\ it was updated using REPLACE INTO myrt VALUES(?,?)… until the day i’ve upgraded to 2.2.11. the update command started to give me: after a bit of investigation i’ve discovered that: with RT index it’s obligatory to have at least one attribute [not id], even ... Read More

sphinx text search – sorting the results by relevancy

2014-03-172016-09-07 by .pQd

a while ago i helped a colleague with moving away from mysql-based text search based on MATCH .. AGAINST to sphinxsearch to improve the performance. without much surprise this helped a lot to improve the response time. recently i was asked to take a look at the setup again and see if we can do ... Read More

new sphinx, new connector/j headaches

2012-01-012016-09-07 by .pQd

sphinx 2.0.3 is out; and as new drama of getting mysql’s connector/j begins. i did not figure out [yet] any way of making both work using the latest 5.1.18 connector, but at least i’ve managed to convince one that i use now [ 5.1.15 ] to work with sphinx. what works: mysql-connector-java-5.1.13-bin.jar but.. only if ... Read More

mysql connector/j 5.1.16 + sphinxql 0.9.9 = MySQLNonTransientConnectionException

2011-05-222012-01-01 by .pQd

most recent connector/j – 5.1.16 does not seem to work with sphinx search 0.9.9. i did not find [yet] actual cause of the problem but going back to 5.1.15 solved the problem for now.