Every day, SteemSQL provides services to dozens of users who hammer the server with thousands of queries. In the meantime, it also has to process all the new blocks, split the data into different tables, update indexes, update non-transactional objects, …
Usually, SteemSQL is close to real-time synced with the blockchain for transactional tables. But with all this work to do and the ever growing number of transactions per day, it sometimes happens that it struggles a bit to sustain the pace, especially when it has to process some resource intensive queries at peak time.
So, from time to time, it happens that SteemSQL is a little late ...
How to know if SteemSQL in sync with the blockchain?
To enable users to monitor SteemSQL, I created a new Server Status page available on SteemSQL website
The page will display the following information:
- The global status of the server:
Online: the server is running and available for users to issue queries
Offline: the server has been shutdown for maintenance - The last irreversible block number from the blockchain
- The last block number in the database
- The sync difference between the blockchain and the database
Detailed tables information
The status page will also display some information for each table into the database:
- the name of the table
- the number of rows into the table
- the size of the table (data + indexes)
This will give you a good idea of the amount of data SteemSQL has to manage (~ 450GB as of today)
Thanks for reading!
footer created with steemitboard - click any award to see my board of honor
Support me and my work as a witness by voting for me here!
