Database / ScyllaDB Interview questions
What is the difference between STCS and LCS compaction?
| Size-Tiered (STCS) | Leveled (LCS) |
| Merges SSTables of similar size together. | Organizes SSTables into size-bounded levels. |
| Lower write amplification; simpler. | Higher write amplification, but bounded per-read SSTable count. |
| Can temporarily need up to 2x disk space during large compactions. | More predictable, smaller space overhead per compaction. |
| Better for write-heavy workloads. | Better for read-heavy workloads needing consistent low latency. |
STCS is the simpler default and works well when write throughput matters most and occasional read amplification is tolerable. LCS trades additional background I/O (more frequent, smaller compactions) for a guarantee that a read only has to check a small, bounded number of SSTables, which keeps read latency more consistent as data grows - the reason it's often recommended for read-heavy tables where p99 latency matters more than raw compaction overhead.
Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!
Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.
Invest now!!! Get Free equity stock (US, UK only)!
Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.
The Robinhood app makes it easy to trade stocks, crypto and more.
Webull! Receive free stock by signing up using the link: Webull signup.
More Related questions...
