0
votes
2answers
480 views

which server(s) should I use for my application? (300GB MySQL DB & Sphinx) [duplicate]

Possible Duplicate: Can you help me with my capacity planning? I have written an application that uses MySQL & Sphinx for searching and storing information. the application contains a ...
0
votes
3answers
401 views

Failed Dependencies for Sphinx Search install

Im Running Centos 5.6 im trying to install Sphinx Search but keep getting errors with missing dependencies. Im running sudo rpm -Uvh sphinx-2.0.2-1.el5.x86_64.rpm error: Failed dependencies: ...
0
votes
1answer
619 views

Installing Sphinx (2.0.1.beta) --with-mysql fails

I am trying to install sphinx on my centOS 5.6 x64 if I do yum install sphinx I get only 0.9,9 version, and I'd like to install 2.0.1-beta so I followed the instructions in their documentation and I ...
0
votes
2answers
205 views

Sphinx indexer slows down the database: How to give it low priority?

All my tables use InnoDB, and I have set sphinx sql_range_step to the minimum, which is 128. This improved the performance a lot, but it is still very slow if you make a request right after a new step ...
2
votes
2answers
325 views

Creating sphinx table in mysql crashes mysql - why?

I've got the latest version of sphinx installed. I have created the index with no problems and searchd starts up with no problems. However, whenever I try to create a test table (straight from the ...