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.
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 page will also display some information for each table into the database:
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.
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!
