Comments

twodollars (52)in chainbb • 7 years ago
RE: chainbb.com - going offline
It was an interesting project, but I'm kind of glad you have decided to focus your time elsewhere because I look forward to checking out your future projects.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.00
0
twodollars (52)in utopian-io • 7 years ago
RE: SBDS to MySQL in Docker
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. du -sh _data/steem/
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.51
Past Payouts $0.51
- Author $0.50
- Curators $0.00
0
twodollars (52)in utopian-io • 7 years ago
RE: SBDS to MySQL in Docker
A monitoring script sounds like a great idea. I'd be happy to help test it out. Various issue's I've experienced are where block height stops going up or one or both of steem_mysql or steem_sbds…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.50
Past Payouts $0.50
- Author $0.38
- Curators $0.12
1
twodollars (52)in utopian-io • 7 years ago
RE: SBDS to MySQL in Docker
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…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.55
Past Payouts $0.55
- Author $0.41
- Curators $0.14
3
twodollars (52)in utopian-io • 7 years ago
RE: SBDS to MySQL in Docker
Are your tests still staying current with the head_block_number? My new test that was at 169G about 18 hours ago stopped growing at 177G and I can't get it to pick back up again. Also, my other…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.58
Past Payouts $0.58
- Author $0.57
- Curators $0.01
3
twodollars (52)in utopian-io • 7 years ago
RE: SBDS to MySQL in Docker
Wow that is a lot of money to spend playing around. Hopefully it will be well worth it for you in the long run as this opens up so many possibilities. Thanks for the reminder about how costs can…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.64
Past Payouts $0.64
- Author $0.48
- Curators $0.16
0
twodollars (52)in utopian-io • 7 years ago
RE: SBDS to MySQL in Docker
I just created a new digitalocean droplet (the 16GB droplet) to try and see what the database size should be, and I'm just following the script you show in this post. Hopefully the database size…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.71
Past Payouts $0.71
- Author $0.53
- Curators $0.17
7
twodollars (52)in utopian-io • 7 years ago
RE: SBDS to MySQL in Docker
The difference is actually larger since 388GB is 370G. The issue is most likely on my end, but I don't think I did anything that should cause data to be missing other than have steem_mysql shut down…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.70
Past Payouts $0.70
- Author $0.52
- Curators $0.17
0
twodollars (52)in utopian-io • 7 years ago
RE: SBDS to MySQL in Docker
Thanks again for putting together such helpful information. This is the way I think people should make tutorials. This is even better than your previous post and that one was very helpful. I had a…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.69
Past Payouts $0.69
- Author $0.53
- Curators $0.17
10
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
Another thing that may be worth considering is that the comments table is the second biggest in storage space, and it may be worthwhile to save space removing removing older edited versions of the…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.69
Past Payouts $0.69
- Author $0.69
- Curators $0.00
1
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
The high memory settings stopped working around noon today so it made it through the last night and and this morning and then failed. I started things up again tonight and noticed the server load go…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.70
Past Payouts $0.70
- Author $0.60
- Curators $0.10
1
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
It is difficult and expensive to be working with such large databases which got me thinking about a way to potentially reduce the size of the database by more than 50% without too much of a…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.64
Past Payouts $0.64
- Author $0.64
- Curators $0.00
3
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
Yes, I've been checking the max block_num against the head_block_number throughout the day, and for the past 24 hours it seems to be keeping up well with about a 20 block lag which seems…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.65
Past Payouts $0.65
- Author $0.65
- Curators $0.00
3
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
I was wondering about the possibility of zipping and tarring up the _data directory to populate sbds instead of using mysqldumps. For example, instead of just offering latest.tar for download on…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.91
Past Payouts $0.91
- Author $0.68
- Curators $0.23
5
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
It still seems to be working, and the lastblock seems to stay very close to the current head_block_number. Thanks for the tip about the _data folder. I was definitely not confident about what I…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.90
Past Payouts $0.90
- Author $0.68
- Curators $0.23
5
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
I haven't been too suspicious about the database restores because I actually did the restores twice (onec on the server I destroyed and once on the current server), and both times seemed to take…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.89
Past Payouts $0.89
- Author $0.67
- Curators $0.22
13
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
I didn't install any other tools in this particular setup (I destroyed the server with the other tools), and I think I adhered very closely to the instructions you provided. I'm using the 16GB…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.86
Past Payouts $0.86
- Author $0.65
- Curators $0.21
15
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
Sorry to keep troubling you. I'm noticing that steem_mysql keeps stopping and gives the following type of error, "Aborted connection 5 to db: 'steem' user: 'root' host: '172.17.0.3' (Got an error…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.84
Past Payouts $0.84
- Author $0.64
- Curators $0.21
17
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
Thanks for helping me with the basics of docker. The "docker ps" showed that steem_mysql wasn't running so I ran "docker start steem_mysql" and then I saw that it was running, but I still couldn't…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.83
Past Payouts $0.83
- Author $0.62
- Curators $0.21
19
twodollars (52)in utopian-io • 7 years ago
RE: MySBDS - Steem Blockchain Data Service in MySQL
I'm running into an issue on my fresh install. The command "mysql -h 172.17.0.2 -u root -p" used to work for me during the download or restore phase, but now that I am in the "build/run sdbs" phase…
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Disagreement on rewards
Fraud or plagiarism
Hate speech or trolling
Miscategorized content or spam

Submit
$0.82
Past Payouts $0.82
- Author $0.61
- Curators $0.20
21