I have a somewhat puzzling situation where Solspace Supersearch (v.2.2.3, EE v2.10.1) times out on very specific search terms. I have tried running the SQL queries corresponding to the same search terms directly from mysql command line and these return pretty quickly (and the number of results is ~30, so this shouldn't be an I/O issue). I've also tried clearing the search log, but that didn't seem to help. I did notice that CPU usage goes through the roof for these searches, mainly for httpd but also for mysql. There doesn't seem to be anything unusual about the search terms that cause the timeouts, e.g. "chili festival" (but NOT "chili peppers").
Any pointers on how I can start debugging this?