EmbeddingGemma 2: an open, lightweight multimodal embedding model
deepmind.google·6d ago
AI Engineering
Lobsters·Sep 7·5 min read
From a Chocolate Wrapper to Concurrent InnoDB Page Splits
TL;DR
A new B-link index implementation for MariaDB significantly enhances InnoDB's insert performance, achieving over 102,000 inserts per second—5.23 times faster than the standard version.
✦ Why It Matters
Consider testing the B-link index prototype to evaluate its performance benefits for your MariaDB workloads.
Key Takeaways
- Explore the B-link index for improved insert performance in MariaDB.
- Evaluate the impact of concurrent page splits on your workloads.
- Test the prototype in a controlled environment before production use.
- Monitor for specific limitations and adjust your implementation strategy accordingly.
How It Works
The B-link index allows for concurrent page splits by publishing structural changes in two phases, enabling searches to proceed even when the tree is temporarily incomplete. This design reduces the need for a global latch, allowing multiple threads to perform independent modifications simultaneously.