Weekly Witness Update

As a witness, I feel it is useful to have a weekly report, which will be produced every weekend at the hashtag #witness-report

Last Report

@justyy 's Weekly Witness Report - 20/Oct/2018

Witness Informatoin

My witness server (Witness Information): (Germany) 10 cores of Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz, 50 GB RAM, 1200 GB SSD, 1000 Mbit/s port, Upstream 130 Gbits, Ubuntu 16.04.

Witness Version

Still 0.20.5 - will upgrade soon.

Block produced in last 7 days

74 blocks produced in last 7 days and rewarded 155191.1334 VESTS in total (approximately 76.1113 Steem Power).

Utopian Moderations

1. Actifit Android V0.4.0 Beta Development Updates
2. Introducing OneLoveDTube IPFS Video Uploader: An alternative way of posting videos onto DTube
3. DriveSoftwarePublisher | Software Publisher using Google Drive | Developement update #3

Blog posts

1. A Simple PHP Command Line Tool to Convert MySQL Tables from MyISAM to InnoDB in Specified Database
2. Installing a VPN on Your Router Is Easier Than You Might Have Thought
3. How to Compute Average of Levels in Binary Tree?
4. How to Design/Implement a Queue using Two Stacks?

API Severs

3 API servers have been upgraded from 0.16.10 yarkey to 0.18.04 bonic. Two more to go!

SteemSQL

According to Hive account@arcange ,

My servers generate more than 600000 queries per day with 3 billion I/O.

I have partially reduced the number of queries by caching and written a script (using NodeJs or Python) to read the blockchain and save the latest posts (3 days) to files or database locally...

This is for supporting the CN community by providing some free services such as curation, RSS...

Chinese Posts 中文

1. 定期请人来家里割草 – 把费时费力的活外包出去
2. 把 MySQL 中的 MyISAM 表格转换成 InnoDB 的PHP小工具

---

Enjoy and Steem On!

Delegate to Hive account@justyy

Hive account@justyy runs a automatic delegation service for nearly a year now. Delegate to Hive account@justyy for at least 5 SP and start receiving daily payout as interests (from 8% to 10% APR). Also, as a supporter, the delegators will start to receive complimentary/curation upvotes (as a thank you) per day from e.g Hive account@justyy and a few other curation trails. For more information, read this. The voting weight algorithm is open source.

• Delegate to Hive account@justyy - at least 5 SP to join (automatically)
• Undelegate to @justyy (Quit) - SP returned by steem blockchain in 5 days
• View Current Delegators/Supporters

Please note that the SP you enter is the final amount to delegate. For example, if you already delegate 10 SP and you want to delegate another 5 SP, you will need to enter 15 SP (instead of 5 SP) in the delegation form.

Vote for me or Set me as a witness Proxy - Every vote counts! - Thank you!

Your Vote is much appreciated, and every vote counts.

Check out My Witness Page

Support me and my work as a witness - witness thread by

1. voting me here, or
2. voting me as a witness proxy - let Hive account@justyy represent you.

Thank you! Some of My Contributions: SteemYY.com - SteemIt Tutorials, Robots, Tools and APIs and VPS Search Tool