by Martin.FarachColton | Jun 6, 2012 | MySQL
Executive Summary Fast indexing requires the leaves of a Fractal Tree® Index to be big. But some queries require the leaves to be small in order to get any reasonable performance. Basements nodes are our way to achieve these conflicting goals, and here I’ll...
by Tim.Callaghan | Jun 5, 2012 | MySQL
I’ll be attending this year’s US based Open Database Camp from June 8-10 in Charlotte, NC. The conference is co-located with SouthEast LinuxFest 2012. It appears that OpenSQL Camp was renamed Open Database Camp since I see many database technologies listed...
by Martin.FarachColton | Jun 4, 2012 | MySQL
The signal-to-noise ratio in the NoSQL world has made it hard to figure out what’s going on, or even who has something new. For all the talk of performance in the NoSQL world, much of the most exciting part of what’s new is really not about performance at all. Take...
by Michael.Bender | Jun 1, 2012 | MySQL
Martin Farach-Colton and I ran a Tutorial on Algorithms for Memory Sensitive Computing on May 18th at the 44th ACM Symposium on Theory of Computing (STOC) at NYU. Here is the program for the tutorial. Erik Demaine (MIT) spoke on the History of I/O Models. Throughout...
by Tokutek | May 30, 2012 | MySQL
TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, and online schema flexibility. Tokutek’s recently launched TokuDB v6 delivers all of these features and more, with the introduction of high...
by kuszmaul | May 24, 2012 | MySQL
Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes; changing schemas without downtime; and...
by Aurimas Mikalauskas | May 24, 2012 | Insight for DBAs, MySQL
I used to think one should never look at max_binlog_size, however last year I had a couple of interesting cases which showed that sometimes it may be very important variable to tune properly. I meant to write about it earlier but never really had a chance to do it. I...
by Tokutek | May 16, 2012 | MySQL
Tackling machine data on the ground to ensure successful operations for NASA in space Issues addressed: Scaling MySQL to multi-terabytes Insertion rates as InnoDB hit a performance wall Schema flexibility to handle an evolving data model The Company: Southwest...
by Tokutek | May 14, 2012 | MySQL
We are excited to have Gerry Narvaja start today at Tokutek! Gerry has spent more than 25 years in the software industry, most of them working with databases for different kinds of applications, from embedded to large-scale web products. Gerry worked first at MySQL,...
by Leif.Walsh | May 10, 2012 | MySQL
In April, I got to give a talk at Percona Live, about why The Right Read Optimization is Actually Write Optimization. It was my first industry talk, so I was delighted when someone in the audience said “I feel like I just earned a college credit.” Box...
by Tokutek | May 2, 2012 | MySQL
MySQL storage engine provider joins forces with leading database consultants to deliver support for growing number of MySQL and MariaDB customers Lexington, MA – (May 2, 2012) – Tokutek, the leader in high-performance and agile database storage engines, today...
by Martin.FarachColton | Apr 30, 2012 | MySQL
TokuDB v6.0 is full of great improvements, like getting rid of slave lag, better compression, improved checkpointing, and support for XA. I’m happy to announce that TokuDB v6.0 is now generally available and can be downloaded here. Sysbench Performance I wanted...
by kuszmaul | Apr 20, 2012 | MySQL
Challenges of Big Databases with MySQL Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes;...
by Tokutek | Apr 18, 2012 | MySQL
Thanks to all of those who came by our booth and to see Leif’s presentation on Read Optimization, and to my Lightning Talk on OLTP and OLAP at the Percona MySQL Conference and Expo. It was an incredible week and a great place to launch TokuDB v6.0 from! A big...
by Leif.Walsh | Apr 13, 2012 | MySQL
This week, I was at Percona Live, and it was a lot of fun! I even got to give a talk on write optimization techniques (not just ours), that I’m told will be online soon. But if you missed that, or even if you didn’t, I’m still in the valley until...
by Martin.FarachColton | Apr 12, 2012 | MySQL
Checkpointing — which involves periodically writing out dirty pages from memory — is central to the design of crash recovery for both TokuDB and InnoDB. A key issue in designing a checkpointing system is how often to checkpoint, and TokuDB takes a very...
by Martin.FarachColton | Apr 11, 2012 | MySQL
A key feature of our new TokuDB v6.0 release, which I have been blogging about this week, is compression. Compression is always on in TokuDB, and the compression we’ve achieved in the past has been quite good. See a previous post on the 18x compression achieved...
by Martin.FarachColton | Apr 10, 2012 | MySQL
Master/slave replication is an important tool that gets used in many ways: distributing read loads among many slaves for performance, using a slave for backups so the master can handle live load, geographically distributed disaster recovery, etc. The Achilles’...
by Martin.FarachColton | Apr 9, 2012 | MySQL
We are excited to announce TokuDB® v6.0, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB. This version offers feature and performance enhancements over previous releases, support for XA (two-phase transactional commits), better...
by Tokutek | Apr 2, 2012 | MySQL
Looks like we’ll be having some more fun at the Percona Live MySQL Conference! In addition to our booth and my colleague Tim’s talk, my lightning talk was accepted. The title is “OLTP and OLAP – Have Your Cake and Eat it Too!” The...
