steemitboard (66)in #sbd • 6 years agoRE: Effect of STEEM and SBD prices on the value of rewardsCongratulations @twodollars! You received a personal award! Birthday! - You are on the Steem blockchain for 2…blervin (54)in #utopian-io • 8 years agoRE: SBDS to MySQL in DockerBack up to sync so I wanted to get some updated totals for you. So, I'm a little confused now. My total size is…blervin (54)in #utopian-io • 8 years agoRE: SBDS to MySQL in DockerSo, I was running some queries, joining between sbds_tx_comments and sbds_tx_votes and found that there was no…blervin (54)in #utopian-io • 8 years agoRE: SBDS to MySQL in DockerThat's exactly what I'm seeing, and every time I fix it, the solution is something that could have been scripted.…blervin (54)in #utopian-io • 8 years agoRE: SBDS to MySQL in DockerGenerally, I stay within about 20 blocks, but sometimes I'll see exactly what you're describing. I just stop…blervin (54)in #utopian-io • 8 years agoRE: SBDS to MySQL in DockerSpeaking of expensive, this hit my bank account yesterday: I was spinning up massive instances and playing around…blervin (54)in #utopian-io • 8 years agoRE: SBDS to MySQL in DockerI'll be interested to see where the new droplet comes out, like you said, hopefully not a third new size. And good…blervin (54)in #utopian-io • 8 years agoRE: SBDS to MySQL in DockerOur discussion in my earlier post formed much of this post so thanks again for sharing everything! So I'm one…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLYeah, great point! The body is fully duplicated on edits so that really could save some significant space.blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLThis is good to hear. I only ran the high memory instance for a couple of days. I thought I had proved it enough, but…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLI've pretty consistently stayed within 20 blocks as well, which is one minute and more than reasonable. You're…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLI've been asking myself this exact same question as well, your approach just may work. I'll definitely post if I find some answers.steemitboard (66)in #sbd • 8 years agoRE: Effect of STEEM and SBD prices on the value of rewardsCongratulations @twodollars! You have completed some achievement on Steemit and have been rewarded with new badge(s)…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLAwesome! To test, I run this a least once a day: SELECT MAX(block_num) AS lastblock FROM sbds_core_blocksblervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLHaha, the .tar download itself was a whole other battle for me. The short answer is the ibdata... and…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLI'm glad it's coming together! It really is a lot of learning little pieces of the puzzle like this to understand…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLAlright, with that deploy when you're doing the database restore, that does hammer mysql pretty hard so that's…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLNo worries, it's good to document these issues in the blockchain so others can learn too! Interestingly, this is one…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLAwesome, glad you got it going! This all underscores how many 'grey areas' I left ambiguous in here, so I'm putting…blervin (54)in #utopian-io • 8 years agoRE: MySBDS - Steem Blockchain Data Service in MySQLCheck docker to make sure mysql is running: docker ps
