@techcoderx Hive witness update log #33: Dev updates for 2H 2024

<hr /> <p dir="auto">A lot has happened since my <a href="/haf/@techcoderx/techcoderx-hive-witness-update-log-32-haf-node-updated-to-v1275rc7">previous<a href="https://3speak.tv/watch?v=aioha/tyaufvzvfg" target="_blank" rel="nofollow noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">keynote presentation at HiveFest 9, for those who missed it.<span> update such as the announcement of <a href="/@aioha">@aioha and the subsequent <p dir="auto">The <a href="https://status.techcoderx.com" target="_blank" rel="nofollow noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">status page has also been working reliably well including notifications of any node issues. There have been two incidents for techcoderx.com API node due to varying causes, both were attended to within 12 hours and fixed promptly while updating it to latest develop at that time whenever possible if a replay is required. <p dir="auto">With that out of the way, below are some highlights of work completed in the last few weeks. <h1>Aioha Core <p dir="auto">As part of <a href="https://github.com/aioha-hive/aioha/releases/tag/v1.5.5" target="_blank" rel="nofollow noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">v1.5.5 release, HiveAuth vendor bundle size have been reduced from 63KB to 12KB which are loaded only when user logs in using the provider. Additionally, a separate <a href="https://aioha.dev/docs/react/provider#ssr-apps" target="_blank" rel="nofollow noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">setup method is now provided for those using SSR frameworks (i.e. Next.js) which are unable to instantiate with <code>initAioha(). <h1>Aioha React UI <p dir="auto">Along with bug fixes for an issue preventing the HiveAuth QR code to be shown, the QR code is now clickable as a link containing the payload. This is needed for those on mobile browsers and have to open a separate PKSA app to authorize the login request. <h1>VSC Blocks <p dir="auto">Major updates underway, currently finalizing VSC-HAF indexer v1.27.6.0.1 which should be ready by next week. Most changes are already live on <a href="https://vsc.techcoderx.com" target="_blank" rel="nofollow noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">vsc.techcoderx.com. There will be a separate announcement on this in the following week. <hr /> <h1>Witness performance <p dir="auto">Current rank: 28th<br /> Votes: 58,607 MVests<br /> Voter count: 175 <p dir="auto">Producer rewards (7 days): 166.817 HP<br /> Producer rewards (30 days): 501.966 HP<br /> Missed blocks (all-time): 32 <h1>Server resource statistics <h4>hived (hive commit <code>54e2d637, haf commit <code>2a091a18) <p dir="auto">block_log file size (compressed): 489 GB<br /> block_log.artifacts file size: 2.1 GB<br /> shared_memory.bin file size: 22 GB <h4>HAF db <p dir="auto">All HAF apps belong to individual schemas in a single PostgreSQL database along with data such as app state providers in the <code>hive schema. This section shows the sizes of each schema in the database using the following query: <pre><code>SELECT schemaname, pg_size_pretty(SUM(pg_total_relation_size(relid))) AS total_size, pg_size_pretty(SUM(pg_table_size(relid))) AS table_size, pg_size_pretty(SUM(pg_indexes_size(relid))) AS indexes_size FROM pg_catalog.pg_statio_user_tables GROUP BY schemaname; <h6>Output <pre><code> schemaname | total_size | table_size | indexes_size -------------------------+------------+------------+-------------- hive | 2968 GB | 1898 GB | 1071 GB hafbe_rep | 26 GB | 26 GB | 441 MB hafah_python | 16 kB | 16 kB | 0 bytes reptracker_account_dump | 8192 bytes | 0 bytes | 8192 bytes hafbe_bal | 82 GB | 67 GB | 15 GB reptracker_app | 362 MB | 260 MB | 102 MB hivemind_app | 751 GB | 411 GB | 340 GB btracker_account_dump | 8192 bytes | 0 bytes | 8192 bytes vsc_app | 54 MB | 46 MB | 8800 kB hafbe_app | 1172 MB | 879 MB | 293 MB hafbe_backend | 16 kB | 8192 bytes | 8192 bytes (12 rows) <h6>Disk usage <p dir="auto">Compressed tablespace: 1.7 TB<br /> Compression ratio: 2.11x <hr /> <p dir="auto"><a href="https://witness.the-hive-mobile.app/#/witnesses/@techcoderx" target="_blank" rel="nofollow noreferrer noopener" title="This link will take you away from hive.blog" class="external_link"><img src="https://images.hive.blog/768x0/https://files.peakd.com/file/peakd-hive/techcoderx/23xVFCjw1rQ1jgXvxu7pBfaLto92QTwngJfDdXW9uPy2KecZfNP9cLR7HouLrk3mshExF.jpg" srcset="https://images.hive.blog/768x0/https://files.peakd.com/file/peakd-hive/techcoderx/23xVFCjw1rQ1jgXvxu7pBfaLto92QTwngJfDdXW9uPy2KecZfNP9cLR7HouLrk3mshExF.jpg 1x, https://images.hive.blog/1536x0/https://files.peakd.com/file/peakd-hive/techcoderx/23xVFCjw1rQ1jgXvxu7pBfaLto92QTwngJfDdXW9uPy2KecZfNP9cLR7HouLrk3mshExF.jpg 2x" />