Maximizing Database Performance: The Benefits of Full Compactions and Automated Scheduling
This blog post describes the benefits of full compactions, some of the scenarios where they are used, and how to best schedule them in YugabyteDB.
This blog post describes the benefits of full compactions, some of the scenarios where they are used, and how to best schedule them in YugabyteDB.
This blog covers the function and implementation compactions, focusing on those details and configurations that are relevant to YugabyteDB. The second half focuses on the behavior and prioritization of background compactions.
In storage systems based on LSM/MVCC, when a record is deleted, it’s not immediately removed. A delete marker (typically called a Tombstone) is placed on the record. As the number of tombstones increases, it could adversely affect the performance of a scan. In this blog, we are going to understand this problem and come up with solutions to address it.