Page 1 of 1

Investigating slowdown

Posted: Thu Sep 17, 2015 10:00 am
by Steve Sokolowski
We're currently investigating why the database is getting behind. We think we have an idea as to why, but it will require a few hours to fix.

Some charts will be out of date in the meantime. Mining and payouts should not be affected. We apologize for the inconvenience.

Re: Investigating slowdown

Posted: Thu Sep 17, 2015 11:25 am
by CptPajamas
Thanks for all your hard work!

Re: Investigating slowdown

Posted: Thu Sep 17, 2015 2:35 pm
by Steve Sokolowski
This issue has been resolved.

For those interested, the problem was that we deleted 160m shares recently in one of our periodic cleanups, but the table had not been VACUUMed. Therefore, there was a huge amount of wasted disk space and it took a long time for the database to figure out where to write the new shares.

By VACUUMing the table, we restored the database to normal operation.