Every day, HiveSQL provides its services to dozens of users and (d)Apps that hammer the server with thousands of queries. At the same time, it also has to process all the new blocks, split the data into different tables, update indexes, update non-transactional tables, etc…
HiveSQL 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, it can sometimes happen that HiveSQL is a little late by a few seconds on the blockchain.
How to check if HiveSQL in sync with the blockchain?
To enable users to monitor HiveSQL, I created a new HiveSQL status page.
The page is available from HiveSQL website or using the following link:
The page will display the following information:
- The status of the server:
Online: the server is running and available for users to issue queries
Offline: the server has been shut down 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 HiveSQL has to manage (more than 2TB as of today) and how many rows each table contains.
As you will see, some tables contain several hundred million records. The Transactions table even contains over 1.365 billion rows!
This is why it is important to carefully write your SQL queries and optimize them. It is a subject on which I will come back later.
Meantime, enjoy this new monitoring tool.
Support
If you have any questions or remarks, support is provided on the HiveSQL Discord Channel.
Thank you for reading.
Let's keep HiveSQL free to use - Support its proposals!
Check out my apps and services
Of course I support the proposal making HiveSQL free again. I used it some back when it was free on Steem and would like to see it supported and free for all again.
Thank you @gregory-f
Voted for both your proposals. Sorry I didn't do that before.
Posted Using LeoFinance Beta
Thank you for your support @ervin-lemark, much appreciated! 🙇
I like it!
I'd personally avoid the long KB and truncate them into GB or MB, but other than tat one small change I really like the look of that.
Nearly half of the table's size still is under 1MB and I prefer not to display decimals to avoid confusion.
I might be adding myself to that list soon. Thanks for keeping it up and working.
Looking forward to you using it @deanlogic
Your post was promoted by @amr008
Awesome , good update . Now I won't need to run the cursor.tables() to see all the tables :)
As klye suggested , I would like to change KB to MB wherever applicable .
Posted Using LeoFinance Beta
Check my reply to @klye about the unit chosen for size ;)
Your "HiveSQL status page" is linked to https://hivesql/status instead of https://hive.arcange.eu/sqlstatus/
yes, it's made it on purpose
Ah... I thought wrong then.
It probably should be an topic most people should look at if they are using HiveSQL. I am also assuming there are indexes on the data so optimizing your queries based on those will be useful.
Posted Using LeoFinance Beta