tag:support.flying-sphinx.com,2011-01-05:/discussions/problems/1852-flying-sphinx-indexing-has-seriously-slowed-down-since-17th-april-0500am-utcFlying Sphinx: Discussion 2016-08-11T01:31:09Ztag:support.flying-sphinx.com,2011-01-05:Comment/366053252015-04-17T14:42:59Z2015-04-17T14:42:59ZFlying-sphinx indexing has seriously slowed down since 17th April 05:00am UTC<div><p>Hi Antti</p>
<p>There was a higher load on your server (Vulcan) for about 24
hours until 04:00 UTC today... it's now back within normal levels,
and certainly this amount of load is not too common (especially for
such a length of time).</p>
<p>I presume this could have been part of what was making things
slower - this is your production app that was having the issues,
right? The last several index runs took about 20-25 seconds going
by the Sphinx logs, so I think this is resolved. If you're seeing
data that suggests otherwise, do let me know.</p>
<p>Certainly if this load issue returns I'll be looking into it in
depth - it's definitely not ideal, especially given you're paying
for something beyond the entry-level plan. I am a little surprised
of the impact that this would have on your database though - if
Sphinx is a little slower at querying data from the DB, surely that
would be less load? But if the timings of slower behaviour in your
app matches the Sphinx indexing calls, then they certainly seem
related.</p>
<p>Kind regards,</p>
<p>Pat</p></div>Pat Allantag:support.flying-sphinx.com,2011-01-05:Comment/366053252015-04-21T15:15:27Z2015-04-21T15:15:27ZFlying-sphinx indexing has seriously slowed down since 17th April 05:00am UTC<div><p>Hi Pat!</p>
<p>Thanks for this information. It seems that indeed our strangely
long index times returned back to normal after the period you
mentioned. We haven’t yet figured out why Sphinx server
slowness had such big effect on our service. (probably something we
could do better) but now it seems things are back to normal, so all
ok for now.</p>
<p>Thanks for quick response again! </p>
<p>-Antti</p>
<p>—— </p>
<p>Best regards from Helsinki,</p>
<p>Antti Virolainen / Co-Founder and
COO at Sharetribe.</p>
<p>Get in touch at <a href="mailto:antti@sharetribe.com">antti@sharetribe.com</a> or Skype
to “gnomet".</p>
<p>Create a marketplace at Sharetribe.com. It only takes
a minute.</p>
<p>On perjantaina, huhtikuuta 17, 2015 at 5:43 ip., Pat Allan
<a href="mailto:tender+dd7fa6860e@tenderapp.com">tender+dd7fa6860e@tenderapp.com</a>,
wrote:</p></div>anttitag:support.flying-sphinx.com,2011-01-05:Comment/366053252015-04-22T00:16:20Z2015-04-22T00:16:20ZFlying-sphinx indexing has seriously slowed down since 17th April 05:00am UTC<div><p>Great to know it’s behaving as expected now :)</p>
<p>I did see another burst of high CPU on Vulcan, which prompted a
change to disable a CPU-intensive feature for apps using recent
versions of the flying-sphinx gem (the feature is related to
working around a limitation of Heroku that no longer exists, hence
not needed in most cases). It was a small thing, but seems to have
helped performance a bit too.</p>
<p>Certainly, if anything else crops up, do let me know.</p>
<p>Cheers</p>
<p>Pat</p></div>Pat Allan