0
votes
1answer
229 views

improving sphinx search performance on an ec2 architecture

I'm working on a m1.large instance in ec2. m1.large 64-bit vCPU -2 ECU-4 Memory -7.5GB DIsks-2 x 420 EBS-Optimized - Yes Network performance: Moderate the index files are on an EBS block with ...
0
votes
2answers
202 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 ...