I'll be interested to see where the new droplet comes out, like you said, hopefully not a third new size.
And good catch! I've added INSTALL MYSQL CLIENT UTILITIES
to the script here now so that'll be installed as well.
Sorry about the extra volumes, I'm glad you caught that early before the cost added up too much. DigitalOcean gets expensive quickly when you get to the larger sizes.
Both my servers are caught up to block 20410475. The _data/steem on the most recent server shows as 437G and the _data/steem on my other server (the one I suspect to be wrong) shows as 377G. it would be nice if your server was at 437G around block 20410475 too, but I'm thinking you probably aren't because you were at 419G four days ago.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
So, I was running some queries, joining between
sbds_tx_comments
andsbds_tx_votes
and found that there was no index onpermlink
in thesbds_tx_votes
table so my join was pretty slow.First of all, adding an index to a 46GB table is basically impossible so I just created a new duplicate table with no data and added an index on that field, then inserted a few thousand records to compare the performance against the primary table. The difference was significant.
So, now I'm carefully re-inserting the entire
sbds_tx_votes
into my newsbds_tx_votes_copy
table with the additional index.I stopped SBDS to avoid new writes while this is running, and I have a new table now too! So, it'll probably be a day or two before I'm back up to the head_block again, and my numbers might be a little different now with the index, but I'll post an update when that's back up.
And I think I might throw in an
ALTER TABLE sbds_tx_votes ADD INDEX...
in my script so this is implemented at the start.Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Back up to sync so I wanted to get some updated totals for you.
So, I'm a little confused now. My total size is now lower than yours from two days ago!
Here's the biggest tables. I thought adding an index to
sbds_tx_votes
would have more of an impact on size, but when I still had both tables they were very close so I'm not sure if that has any impact here.Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes, I'm confused by things too. Here is my current data for my most recent server around block number 20475678. I was very careful to follow the script with this server.
Note: I tried comparing this server with the other server I have running sbds to see if I could identify why one was bigger than the other, and I notice that the data contained in the 'raw' field in the 'sbds_core_blocks' table doesn't seem to match on both servers. For example, the 'raw' field for 'block_num' 20470001 on one server is different than the same raw field on the other server.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit