About a month ago I posted concerning connection timeouts. Thankfully it was the usual crap and with a little help here on the forum I was up and running rather quickly. Things have been running perfectly for almost a month now. Until yesterday. Suddenly the users began complaining about server crashes when they ran full text searches. I examined the log and, sure enough, there were connection errors happening yesterday. Today, however, all full text searches are working perfectly. I'm guessing this is a performance issue -- that queries are getting clobbered during indexing runs. Delta indexing is not possible for my configuration, so I'm running the indexer once an hour. It's a fairly large index.
I went to the Sphinx site and consulted the forum and documentation for performance tuning advice. I found some interesting configuration parameters (max_iops, max_iosize and agent_connect_timeout) but thought it would be wise to post here for tips on how to tweak performance to avoid these connection timeouts rather than randomly tweaking parameters. Any advice would be greatly appreciated as to what parameters might solve this problem, what values would make sense and exactly how/where to set them in Thinking Sphinx. Thanks for your help, Stan -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
