by Tim.Callaghan | Jan 26, 2012 | MySQL
iiBench measures the rate at which a database can insert new rows while maintaining several secondary indexes. We ran this for 1 billion rows with TokuDB and InnoDB starting last week, right after we launched TokuDB v5.2. While TokuDB completed it in 15 hours, InnoDB...
by Tim.Callaghan | Jan 11, 2012 | MySQL
Thanks again to Sheeri Cabral for having me at the Boston MySQL Meetup on Monday for the talk on “Fractal Tree® Indexes – Theoretical Overview and Customer Use Cases.” The crowd was very interactive, and I appreciated that over 50 people signed up for the...
by Jay Janssen | Dec 16, 2011 | MySQL
There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority of use...
by Tokutek | Dec 14, 2011 | MySQL
Limelight Networks Issue addressed: Managing metadata at exabyte scale Delivering Agile Storage in the Cloud with Billions of Assets The Company: Founded in 2001, Limelight Networks, Inc (NASDAQ: LLNW) is an Internet platform and services company that integrates the...
by Tim.Callaghan | Dec 5, 2011 | MySQL
At next month’s Boston MySQL Meetup, I will give a talk: “Fractal Tree Indexes – Theoretical Overview and Customer Use Cases.” The meetup is 7 pm Monday, January 9th, 2012, and will be held at MIT Building E51 Room 337e (corner of Ames & Amherst St,...
by Zardosht.Kasheff | Nov 21, 2011 | MySQL
As a storage engine developer, I am excited for MySQL 5.6. Looking at http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html, there has been plenty of work done to improve the performance of reads in MySQL for all storage engines (provided they take...
by kuszmaul | Oct 25, 2011 | 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 supporting...
by Tim.Callaghan | Oct 20, 2011 | MySQL
I’ve been benchmarking and testing TokuDB for a few months now. One goal of benchmarking is to understand what is limiting the performance of a particular configuration. I frequently use “show engine [innodb/tokudb] status;” from within the MySQL...
by Tokutek | Jul 25, 2011 | MySQL
We were happy to see a lot of folks from Japan on Twitter this weekend having a discussion about MySQL and Tokutek. While we always endeavor to explain ourselves as simply as possible, hearing what users and peers have to say and ask in their native language is very...
by Tokutek | Jul 18, 2011 | MySQL
Unless you are Ashton Kutcher (@aplusk), or one of his Hollywood buddies, you don’t need to read any further. Allow me to explain… Over the weekend, we launched our new website. This type of announcement used to be interesting in the high-tech world. I heard Kara...
by Zardosht.Kasheff | Jul 15, 2011 | MySQL
Thanks again to Erin O’Neill and Mike Tougeron for having me at the SF MySQL Meetup last month for the talk on “Understanding Indexing.” The crowd was very interactive, and I appreciated that over 100 people signed up for the event and left some very positive comments...
by Tokutek | Apr 19, 2011 | MySQL
What a busy week – between O’Reilly and Collaborate we gave a number of talks, sponsored a booth, and took some long flights in between the shows. But what an interesting week. The MySQL conference is a great time to catch up with customers and, as always,...
by Fernando Ipar | Apr 7, 2011 | Insight for Developers, MySQL
I recently worked on a customer case where at seemingly random times, inserts would fail with Innodb error 139. This is a rather simple problem, but due to it’s nature, it may only affect you after you already have a system running in production for a while....
by kuszmaul | May 11, 2010 | MySQL
I just spotted the youtube video of my OpenSQL Camp (Portland 2009) talk on An Open Storage Engine API. I talked about some of technical issues for implementing storage engines across many SQL front ends, not just MySQL. You can find this talk and other mostly...
by Morgan Tocker | Nov 20, 2009 | Insight for Developers, MySQL
Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions – as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul! What’s the “ideal” use case for the...
by Morgan Tocker | Nov 16, 2009 | Insight for DBAs, MySQL
I forwarded on a list of questions about PBXT to Paul McCullagh today. While Paul’s busy answering them, I’d like to announce that Robert Dempsey (InfiniDB storage engine) and Bradley C. Kuszmaul (TokuDB storage engine) have also accepted an interview....
by Aleksandr Kuzminsky | Jul 20, 2009 | Percona Software
Dear community, Today we are pleased to announce release 6 of XtraDB – the result of 2 months hard work. The release includes following new features: MySQL 5.1.36 as a base release New patch innodb_recovery_patches.patch 1 innodb_recovery_patches.patch...
by Vadim Tkachenko | Jun 11, 2009 | Insight for DBAs
Playing with TokuDB updates I noticed in SHOW PROCESSLIST unsual for MySQL State. mysql> show processlist; +----+------+-----------+--------+---------+------+---------------------------+-----------------------------+ | Id | User | Host | db | Command | Time | State...
by Vadim Tkachenko | Apr 28, 2009 | Uncategorized
(Note: Review was done as part of our consulting practice, but is totally independent and fully reflects our opinion) I had a chance to take look TokuDB (the name of the Tokutek storage engine), and run some benchmarks. Tuning of TokuDB is much easier than InnoDB,...
by Baron Schwartz | Apr 15, 2009 | Insight for DBAs
Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages from the buffer pool. These are pages that have been modified in memory, but not on disk. If you kill the server before it finishes this process, it will...
