Dhwanil Shahthebackspace.hashnode.dev·Oct 21, 2024Embedded DatabasesWhen considering constructing a system, we often default to using complex databases like MySQL, PostgreSQL, Oracle DB, SQL Server, or MongoDB without pausing to consider if a simpler system would suffice for managing our data. These have become the d...Discuss·28 readsembedded db
Olalekan Adekolalexyblazy.hashnode.dev·Oct 18, 2024Let's build a Full-Text Search engine (Part 2)“Where is part one?” asked the reader. Part one was written by Artem Krylysov and is a prerequisite to understanding this article. You can find part one here. I’d like to mention that besides introducing a disk-based persistence layer for the projec...Discuss·65 readsGo Language
Shiv Iyershiviyer.hashnode.dev·Jan 26, 2024Optimizing Memory Management in Percona Server for MySQL with RocksDB ConfigurationTo configure the rocksdb_strict_capacity_limit and rocksdb_soft_pending_compaction_bytes_limit variables in Percona Server for MySQL for memory management: rocksdb_strict_capacity_limit: This variable, when enabled, enforces a strict limit on the am...Discuss·69 readsMySQL
Shiv Iyershiviyer.hashnode.dev·Jan 25, 2024Optimizing RAM Allocation for Thread Cache Performance in RocksDB: A Guide to Effective TuningTuning the available RAM for thread cache performance in RocksDB, a high-performance key-value store, is crucial for optimizing its overall performance. The thread cache in RocksDB is primarily controlled by the Block Cache setting, which determines ...DiscussTroubleshooting MySQL PerformanceMySQL