Home / server / Questions / 260750
In Process
HappyDeveloper
Asked: 2011-04-18 14:12:04 +0800 CST

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

  • 772

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 begins.

I'm sure it would work just fine if I could reduce the range step to 10 or something, but someone found that the min value is hardcoded and there is no way to change it (other than editing the source).

So I was wondering if there was a way to deal with this directly from MySQL. When I am indexing a database, the other databases aren't affected, so it's not the whole server which has been slowed down, but only the database I am indexing.

Is there a way to give less priority to a user or query, or something?

performance mysql sphinx

2 Answers

  1. Take a look at this similar post from StackOverflow. You may be able to use those strategies to give sphinx a lower priority.

    • 0

  2. Have a look at this

    The idea is to insert some code in your query that is throttling down query execution.

    For a quickest approach you can use a query like this:

    select <your stuff> from <your table where <your condition> and (sleep (0.1) or 1)

    That will make sphinx query to wait for 0.1 seconds before finishing.

    • 0