by Tokutek | Mar 23, 2011 | MySQL
The Big Data Opportunity “What if you could analyze every transaction, capture insights from every customer interaction, and didn’t have to wait for months to get data from the field?”- McKinsey Column, Financial Times Despite this tremendous opportunity, MySQL...
by Zardosht.Kasheff | Mar 16, 2011 | MySQL
Yesterday, at the Boston MySQL Meetup, I gave a talk on indexing. It is posted here (also goo.gl/S2LBe). In short, indexes are used to improve query performance. As a result, good indexes are designed around queries that users find important in their application. The...
by Ryan Lowe | Mar 16, 2011 | Insight for DBAs, MySQL
HandlerSocket has really generated a lot of interest because of the dual promises of ease-of-use and blazing-fast performance. The performance comes from eliminating CPU consumption. Akira Higuchi’s HandlerSocket presentation from a couple of months back had...
by Ryan Lowe | Mar 14, 2011 | Cloud, MySQL, Percona Events
On March 29th, I’ll be giving a webinar whose title is “Understanding HandlerSocket – A NoSQL PlugIn For MySQLâ€. This is a continuation and extension of the talk I gave during the Percona Live Event in San Francisco back in February. We’ll ask, and...
by Martin.FarachColton | Mar 11, 2011 | MySQL
In Part 1, and Part 2 of this series, I presented some thoughts on partitioning. I heard some great feedback on why people use partitioning. Here, I present a flow chart that summarizes what I’ve learned. In summary: with TokuDB in the picture there’s...
by Tokutek | Feb 24, 2011 | MySQL
John Partridge, President and CEO of Tokutek, sits down to talk about MySQL performance and scalability with the Wikibon Project’s Dave Vellante at last week’s MassTLC Big Data Summit....
by Tokutek | Feb 18, 2011 | MySQL
This was an interesting week for data discussions in the Boston area. There were two back-to-back events this week — Big Data on Wednesday night hosted by TiE Boston and Channeling the Big Data Tsunami by MassTLC on Thursday morning. With desperate sounding...
by Michael.Bender | Feb 14, 2011 | MySQL
I gave a talk entitled “How to Index Massive Data Sets Quickly” at the Morrelly Homeland Security Center. The event was hosted at the Long Island Forum for Technology (LIFT) and was jointly supported by NYSTAR and the Stony Brook Sensor CAT. The audience...
by Tokutek | Feb 2, 2011 | MySQL
I am delighted to announce that Dr. Bradley Kuszmaul, Co-Founder and Chief Architect at Tokutek, has been appointed to the IOUG’s first MySQL Council. In the announcement on the IUOG website, president Andy Flower spoke highly of the MySQL Council’s new members Sarah...
by Tokutek | Feb 1, 2011 | MySQL
Links to the FAQ Sections can be found here: General Information Open Source Technical Details Best Practices and Tools General Information ANY CHARACTER HERE 1. What is TokuDB? TokuDB is an ACID compliant storage engine for MySQL that is specifically designed for...
by Martin.FarachColton | Jan 28, 2011 | MySQL
Review In part one, I presented a very brief and particular view of partitioning. I covered what partitioning is, with hardly a mention of why one would use partitioning. In this post, I’ll talk about a few use cases often cited as justification for using...
by Martin.FarachColton | Jan 21, 2011 | MySQL
Why Partition a Database? Partitioning is a commonly touted method for achieving performance in MySQL and other databases. (See here, here, here and many other examples.) I started wondering where the performance from partitions comes from, and I’ve summarized...
by Morgan Tocker | Jan 5, 2011 | MySQL, Percona Events
Today we’re announcing Percona Live – a one day event to be held at the Bently Reserve on February 16th in San Francisco. Live is our way of showcasing some of the awesome work that has been going into MySQL recently – and the theme of this event...
by John.Partridge | Dec 9, 2010 | MySQL
Tokutek is pleased to announce support for MariaDB for the first time with TokuDB v4.1.1 for MariaDB v5.1.47. Our customers are choosing MariaDB more and more frequently for their most demanding database applications. We are delighted to help raise MariaDB performance...
by Martin.FarachColton | Nov 17, 2010 | MySQL
Summary B-trees suffer from fragmentation. Fragmentation causes headaches — in query performance and space used. Solutions, like dump and reload or OPTIMIZE TABLE are a pain and not always effective. Fractal trees don’t fragment. So if fragmentation is a...
by Morgan Tocker | Oct 26, 2010 | Benchmarks, Insight for Developers, MySQL
A couple of weeks ago I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a few people wrote in to suggest alternative ways of implementing this. I just got around to benchmarking those alternatives today across two large...
by Morgan Tocker | Oct 4, 2010 | Benchmarks, Insight for Developers, MySQL
The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar – and I thought I would share with you my favorite two: Option #1: Use a table to insert into, and grab the insert_id: CREATE TABLE option1...
by Tokutek | Sep 2, 2010 | MySQL
Often, the first step in evaluating and deploying a database is to load an existing dataset into the database. In the latest version, TokuDB makes use of multi-core parallelism to speed up loading (and new index creation). Using the loader, MySQL tables using TokuDB...
by Rich.Prohaska | Aug 27, 2010 | MySQL
TokuDB has a big advantage over B-trees when trickle loading data into existing tables. However, it is possible to preprocess the data when bulk loading into empty tables or when new indexes are created. TokuDB release 4 now uses a parallel algorithm to speed up these...
by John.Partridge | Aug 19, 2010 | MySQL
Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.1.1. It is ideally suited for delivering fast response times for complex / high-volume Web applications that must simultaneously store and query large volumes of rapidly arriving...
