by Tokutek | Apr 11, 2011 | MySQL
Jawa Issue addressed: Process over 10 million log entries per day without partitions or other workarounds. MySQL + TokuDB Tames Huge Logfile Processing Workload The Company: Founded in 2005, Jawa develops software and media solutions enabling people to stay connected...
by kuszmaul | Apr 9, 2011 | MySQL
We’ve been busy at The MySQL Council. Giuseppe’s summary does a good job explaining what we’ve been up to. You can communicate with the MySQL council in several ways including: Respond to the MySQL Council Survey. Talk to one of the council members....
by Martin.FarachColton | Apr 8, 2011 | MySQL
Why do B-trees need “Tricks” to work? Marko Mäkelä recently posted a couple of “tips and tricks” you can use to improve InnoDB performance. Tips and tricks. A general purpose relational database like MySQL shouldn’t need “tips and...
by Martin.FarachColton | Apr 7, 2011 | MySQL
Hot Column Addition and Deletion (HCAD) In the previous HCAD post, I described HCAD and showed that it can reduce the downtime of column addition (or deletion) from 18 hours to 3 seconds. In fact, the downtime of InnoDB is proportional to the size of the database,...
by Aurimas Mikalauskas | Apr 7, 2011 | Insight for DBAs, MySQL
I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I’ve been using mk-query-digest for almost as long as it exists but it continues to surprise me in ways I couldn’t imagine it would. This...
by Tokutek | Apr 6, 2011 | MySQL
Tokutek, the leading innovator in high-performance and agile schema storage engines, announced today that its team members will be speaking at both the IOUG Collaborate 11 in Orlando, FL, on April 11, 2011 and the O’Reilly MySQL Conference in Santa Clara, CA, on April...
by Martin.FarachColton | Apr 5, 2011 | MySQL
From 31 minutes to 2 seconds Hot Indexing Overview TokuDB v5.0 introduces several features that are new to the MySQL world. Recently, we posted on HCAD: Hot Column addition and Deletion. In this post, we talk about Hot Indexing. What happens when you try to add a new...
by Tokutek | Apr 4, 2011 | MySQL
Keeping from Getting Buried in Big Data Boy, what a way to go into spring. We are expecting up to 1/2″ of rain (or perhaps sleet) today. This follows the 3″ of snow we had on Friday (Shaq — watch out we long ago got Nate – you are next). Here...
by Martin.FarachColton | Mar 30, 2011 | MySQL
From 18 hours to 3 seconds! Hot Column Addition and Deletion (HCAD) Overview TokuDB v5.0 introduces several features that are new to the MySQL world. In this series of posts, we’re going to present some information on these features: what’s the feature,...
by Tokutek | Mar 29, 2011 | MySQL
Running with Big Data It’s spring here in Boston, though one could hardly tell (still barely hitting 40°F). So, for those stuck indoors working out on the treadmill, or those lucky enough to do a workout outdoors, we’ve got a great podcast. Our Chief...
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...