• steemitboard (66)in #sbd • 6 years ago

  RE: Effect of STEEM and SBD prices on the value of rewards

  Congratulations @twodollars! You received a personal award! Birthday! - You are on the Steem blockchain for 2 years! You can view your badges on your Steem Board and…

  $0.00

   0 0
• blervin (56)in #utopian-io • 7 years ago

  RE: SBDS to MySQL in Docker

  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! # du -sh _data/steem/

  $0.52

  • Past Payouts $0.52
  • - Author $0.39
  • - Curators $0.13

   1 1
• blervin (56)in #utopian-io • 7 years ago

  RE: SBDS to MySQL in Docker

  So, I was running some queries, joining between sbds_tx_comments and sbds_tx_votes and found that there was no index on permlink in the sbds_tx_votes table so my join was…

  $0.54

  • Past Payouts $0.54
  • - Author $0.41
  • - Curators $0.14

   1 0
• blervin (56)in #utopian-io • 7 years ago

  RE: SBDS to MySQL in Docker

  That's exactly what I'm seeing, and every time I fix it, the solution is something that could have been scripted. I'll definitely ping you when I have something together for testing.

  $0.51

  • Past Payouts $0.51
  • - Author $0.38
  • - Curators $0.13

   1 0
• blervin (56)in #utopian-io • 7 years ago

  RE: SBDS to MySQL in Docker

  Generally, I stay within about 20 blocks, but sometimes I'll see exactly what you're describing. I just stop SBDS, restart, and watch the logs: # docker stop steem_sbds

  $0.64

  • Past Payouts $0.64
  • - Author $0.48
  • - Curators $0.16

   1 2
• blervin (56)in #utopian-io • 7 years ago

  RE: SBDS to MySQL in Docker

  Speaking of expensive, this hit my bank account yesterday: I was spinning up massive instances and playing around this month, obviously far more than I thought. This…

  $0.67

  • Past Payouts $0.67
  • - Author $0.50
  • - Curators $0.16

   1 1
• blervin (56)in #utopian-io • 7 years ago

  RE: SBDS to MySQL in Docker

  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…

  $0.73

  • Past Payouts $0.73
  • - Author $0.55
  • - Curators $0.18

   1 4
• blervin (56)in #utopian-io • 7 years ago

  RE: SBDS to MySQL in Docker

  Our discussion in my earlier post formed much of this post so thanks again for sharing everything! So I'm one folder deeper in _data/steem/ running this command…

  $0.66

  • Past Payouts $0.66
  • - Author $0.50
  • - Curators $0.16

   1 9
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  Yeah, great point! The body is fully duplicated on edits so that really could save some significant space.

  $0.00

   0 0
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  This is good to hear. I only ran the high memory instance for a couple of days. I thought I had proved it enough, but obviously there's more to learn there. As far as changing…

  $0.72

  • Past Payouts $0.72
  • - Author $0.54
  • - Curators $0.18

   1 0
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  I've pretty consistently stayed within 20 blocks as well, which is one minute and more than reasonable. You're exactly right, the settings you changed are exactly what to…

  $0.75

  • Past Payouts $0.75
  • - Author $0.57
  • - Curators $0.19

   1 2
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  I've been asking myself this exact same question as well, your approach just may work. I'll definitely post if I find some answers.

  $0.77

  • Past Payouts $0.77
  • - Author $0.58
  • - Curators $0.19

   1 2
• steemitboard (66)in #sbd • 7 years ago

  RE: Effect of STEEM and SBD prices on the value of rewards

  Congratulations @twodollars! You have completed some achievement on Steemit and have been rewarded with new badge(s) : Award for the number of comments received Click on…

  $0.00

   0 0
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  Awesome! To test, I run this a least once a day: SELECT MAX(block_num) AS lastblock FROM sbds_core_blocks

  $0.73

  • Past Payouts $0.73
  • - Author $0.55
  • - Curators $0.18

   1 4
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  Haha, the .tar download itself was a whole other battle for me. The short answer is the ibdata... and ib_logfile... files are required as well as the steem/ folder…

  $0.72

  • Past Payouts $0.72
  • - Author $0.54
  • - Curators $0.18

   1 4
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  I'm glad it's coming together! It really is a lot of learning little pieces of the puzzle like this to understand everything. I'm still getting that tutorial together to walk…

  $0.92

  • Past Payouts $0.92
  • - Author $0.69
  • - Curators $0.23

   1 12
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  Alright, with that deploy when you're doing the database restore, that does hammer mysql pretty hard so that's probably the main issue here. Again, check the docker logs to…

  $0.87

  • Past Payouts $0.87
  • - Author $0.65
  • - Curators $0.21

   1 14
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  No worries, it's good to document these issues in the blockchain so others can learn too! Interestingly, this is one issue I have not yet run into. For me, steem_mysql has…

  $0.85

  • Past Payouts $0.85
  • - Author $0.65
  • - Curators $0.20

   1 16
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  Awesome, glad you got it going! This all underscores how many 'grey areas' I left ambiguous in here, so I'm putting together a more thorough tutorial that'll go into docker and…

  $0.89

  • Past Payouts $0.89
  • - Author $0.67
  • - Curators $0.22

   1 18
• blervin (56)in #utopian-io • 7 years ago

  RE: MySBDS - Steem Blockchain Data Service in MySQL

  Check docker to make sure mysql is running: docker ps

  $0.90

  • Past Payouts $0.90
  • - Author $0.68
  • - Curators $0.23

   1 20