Problem with Sphinx resultset larger than 16 MB in MySQL

Posted by gmemon on Stack Overflow See other posts from Stack Overflow or by gmemon
Published on 2010-04-30T21:49:38Z Indexed on 2010/04/30 21:57 UTC
Read the original article Hit count: 314

Filed under:
|
|

Hello All,

I am accessing a large indexed text dataset using sphinxse via MySQL. The size of resultset is on the order of gigabytes. However, I have noticed that MySQL stops the query with following error whenever the dataset is larger than 16MB:

1430 (HY000): There was a problem processing the query on the foreign data source. Data source error: bad searchd response length (length=16777523)

length shows the length of resultset that offended MySQL. I have tried the same query with Sphinx's standalone search program. It works fine. I have tried all possible variables in both MySQL and Sphinx, but nothing is helping.

I am using Sphinx 0.9.9 rc-2 and MySQL 5.1.46.

Thanks

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sphinx