• Sign in
  • Sign up 
  • Welcome
  • FAQ
  • Block Explorer 
  • Night Mode
  • Stolen Accounts Recovery 
  • Change Account Password 
  • Vote for Witnesses 
  • Hive Proposals 
  • OpenHive Chat 
  • Developer Portal 
  • Hive Whitepaper 
  • Privacy Policy
  • Terms of Service
logo
  • Posts
  • Proposals
  • Witnesses
  • Our dApps
LoginSign up

twodollars (52)Hivebuzz level badge

197 followers111 posts19 following704 HP
Blacklisted Users
Muted UsersFollowed BlacklistsFollowed Muted Lists

Joined July 2017 Active 7 years ago

  • Blog
  • Posts
  • Replies
  • Social
  • Notifications
  • Wallet
  • steemitboard (66)in #sbd • 6 years ago
    featured

    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 • 8 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 • 8 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 • 8 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 • 8 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 • 8 years ago
      featured

      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 • 8 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 • 8 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 • 8 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 • 8 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 • 8 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 • 8 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 • 8 years ago
        featured

        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 • 8 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 • 8 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 • 8 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 • 8 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 • 8 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 • 8 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 • 8 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