There is obviously much being written these days about Big Data. While the term has many different meanings to many different folks, our MySQL and MariaDB customers tend to find their data to be uncomfortably big when the tables become too large for memory. In this case, more storage has to be acquired, performance starts to lag, and making changes to the schema becomes a challenge.
TokuDB addresses these issues for big MySQL instances by delivering high compression rates, faster insertion and query performance, and agile schema changes. That said, many people who evaluate TokuDB have smaller databases (where tables fit in memory) that they anticipate will grow larger. They wonder if starting with TokuDB makes sense up front.
Recently, Database Journal posed this question and performed some benchmarks of TokuDB on a smaller dataset. The answer to whether TokuDB should be used for smaller data sets was a resounding “yes”, as the reviewer at Database Journal saw improvements in record insertion perfromance, queries with a table scan, lookup speed, and column management. See here for details.
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below.