Investigating slowdown

Steve Sokolowski · Thu Sep 17, 2015 02:00 PM UTC

Investigating slowdown

by Steve Sokolowski · Thu Sep 17, 2015 02:00 PM UTC · Post #2138

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.

CptPajamas · Thu Sep 17, 2015 03:25 PM UTC

Re: Investigating slowdown

by CptPajamas · Thu Sep 17, 2015 03:25 PM UTC · Post #2139

Thanks for all your hard work!

Steve Sokolowski · Thu Sep 17, 2015 06:35 PM UTC

Re: Investigating slowdown

by Steve Sokolowski · Thu Sep 17, 2015 06:35 PM UTC · Post #2140

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.