by Tokutek | Oct 4, 2012 | MySQL
TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, replication performance and online schema flexibility. Tokutek’s recently launched TokuDB v6.5 delivers all of these features and...
by Tim.Callaghan | Oct 3, 2012 | MySQL
Tokutek sponsored the Percona Live MySQL / New York 2012 Conference which took place this past Monday and Tuesday. I spent much of the time at our booth discussing TokuDB with conference attendees but also managed to attend the following presentations: Understanding...
by Tim.Callaghan | Sep 29, 2012 | MySQL
TokuDB v6.5 adds the ability to expand certain column types without downtime. Users can now enlarge char, varchar, varbinary, and integer columns with no interruption to insert/update/delete statements on the altered table. Prior to this feature, enlarging one of...
by kuszmaul | Sep 27, 2012 | MySQL
Since Fractal Tree indexes turn random writes into sequential writes, it’s easy to see why they offer a big advantage for maintaining indexes on rotating disks. It turns out that that Fractal Tree indexing also offers signficant advantages on SSD. Here are three...
by Martin.FarachColton | Sep 25, 2012 | MySQL
We are excited to announce TokuDB® v6.5, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB. This version offers optimization for Flash as well as more hot schema change operations for improved agility. We’ll be posting more...
by Tokutek | Sep 24, 2012 | MySQL
On Friday our CEO John Partridge was named a “Tech Luminary” in the 17th annual Innovation All Stars award, which is given jointly by Mass High Tech (MHT) and the Boston Business Journal (BBJ). As noted in MHT by the editor, Chris McIntosh, the Luminary...
by Zardosht.Kasheff | Sep 18, 2012 | MySQL
At next week’s Strange Loop conference, I will give a talk on “Understanding Indexing”. The session is 10 am Monday, September 24th, and will be held in the Midland States Room.
by Tim.Callaghan | Sep 13, 2012 | MySQL
In my three previous blogs I wrote about our implementation of Fractal Tree Indexes on MongoDB, showing a 10x insertion performance increase, a 268x query performance increase, and a comparison of covered indexes and clustered indexes. The benchmarks show the...
by kuszmaul | Sep 7, 2012 | MySQL
Next week Michael and I (Bradley) will be travelling to Silicon Valley to present a tutorial on Data Structures and Algorithms for Big Databases at the 6th XLDB Conference. The tutorial, which is 4 hours on Monday afternoon, aims to cover the following topics (but...
by Tim.Callaghan | Sep 6, 2012 | MySQL
In my two previous blogs I wrote about our implementation of Fractal Tree Indexes on MongoDB, showing a 10x insertion performance increase and a 268x query performance increase. MongoDB’s covered indexes can provide some performance benefits over a regular MongoDB...
by Tim.Callaghan | Aug 30, 2012 | MySQL
Last week I wrote about our 10x insertion performance increase with MongoDB. We’ve continued our experimental integration of Fractal Tree® Indexes into MongoDB, adding support for clustered indexes. A clustered index stores all non-index fields as the “value” portion...
by Aurimas Mikalauskas | Aug 29, 2012 | Insight for DBAs, MySQL
If you ever had a replication slave that is severely behind, you probably noticed that it’s not catching up with a busy master at a steady pace. Instead, the “Seconds behind master” is going up and down so you can’t really tell whether the...
by Tim.Callaghan | Aug 23, 2012 | MySQL
The challenge of handling massive data processing workloads has spawned many new innovations and techniques in the database world, from indexing innovations like our Fractal Tree® technology to a myriad of “NoSQL” solutions (here is our Chief Scientist’s perspective)....
by Tokutek | Aug 22, 2012 | MySQL
Businesses increasingly operate in a 24×7 environment, where complex analytics must be performed on live, continuously incoming “Big Data.” To address this, TokuDB has developed Fractal Tree® technology, a revolutionary new indexing capability that enables...
by kuszmaul | Aug 14, 2012 | MySQL
Next week I (Bradley) will be traveling to FROSCON near Bonn, Germany, and then on to VLDB in Istanbul. At FROSCON I’ll be talking about fast data structures for maintaining indexes. The talk will share some content with my upcoming MySQL Connect talk. At VLDB,...
by Michael.Bender | Aug 7, 2012 | MySQL
A few weeks ago Bradley Kuszmaul and I attended the Dagstuhl Seminar on Database Workload Management. The Dagstuhl computer science research center is (remotely) located in the countryside in Saarland, Germany. The actual building is an 18th Century Manor House, first...
by Tim.Callaghan | Aug 1, 2012 | MySQL
Benchmarking is a tricky thing, especially when it comes to compression. Some data compresses quite well while other data does not compress at all. Storing jpeg images in a BLOB column produces 0% compression, but storing the string “AAAAAAAAAAAAAAAAAAAA” in a...
by Tim.Callaghan | Jul 24, 2012 | MySQL
I’ll be presenting TokuDB at the Emerging Business Technology Meetup in Boston this Thursday night at 6pm at 290 Congress St (near South Station). The meeting topic is “NewSQL: SQL Technologies Keeping NoSQL Promises” and also includes presentations...
by Zardosht.Kasheff | Jul 23, 2012 | MySQL
Three rules on making indexes around queries to provide good performance Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase...
by Tim.Callaghan | Jul 18, 2012 | MySQL
TokuDB v6.1 is now generally available and can be downloaded here. New features include: Added support for MariaDB 5.5 (5.5.25) The TokuDB storage engine is now available with all the additional functionality of MariaDB 5.5. Added HCAD support to our MySQL 5.5 version...