by Przemysław Malkowski | Feb 24, 2014 | Benchmarks, Insight for DBAs, MySQL
In my previous post I pointed out that the existing ARCHIVE storage engine in MySQL may not be the one that will satisfy your needs when it comes to effectively storing large and/or old data. But are there any good alternatives? As the primary purpose of this engine...
by Zardosht.Kasheff | Feb 3, 2014 | MySQL
William Zola over at MongoDB gave a great talk called “The (Only) Three Reasons for Slow MongoDB Performance”. It reminded me of an interesting characteristic of updates in MongoDB. Because MongoDB’s main data store is a flat file and secondary indexes store offsets...
by Dave Rosenlund | Jan 21, 2014 | MySQL
You love MySQL and MariaDB for its ease of deployment, but what if you could increase performance and save significant time and money when your application starts to scale without having to change your applications? Register Now! SPEAKER: Tim Callaghan, VP of...
by Dave Rosenlund | Dec 6, 2013 | MySQL
Nominate Tokutek for the 2013 Best Technology Achievement Crunchies award! Help us be recognized for our database performance engines, TokuMX™ and TokuDB, and our revolutionary Fractal Tree® technology. Nominations will only be accepted until December 15, 2013 at...
by Rich.Prohaska | Nov 19, 2013 | MySQL
What does it mean if MySQL returns the ‘Incorrect key file for table’ error for one of my queries? The answer is complicated and depends on which storage engine is returning the error. We have debugged two cases which we describe here. File system out of...
by Dave Rosenlund | Nov 8, 2013 | MySQL
Attending Percona Live in London next week? Don’t miss the chance to hear Tokutek’s Vice President of Engineering, Tim Callaghan, discuss how to use your MySQL knowledge to become an instant MongoDB Guru and the advantages of using Fractal Tree® indexes in...
by Dave Rosenlund | Oct 30, 2013 | MySQL
You love MySQL for its ease of deployment – but are you worried about how your application will perform when it starts to scale? SPEAKER: Gerry Narvaja, Tokutek DATE: Wednesday, November 6th TIME: 1pm ET Register Now! Join this interactive webinar with Gerry...
by Rich.Prohaska | Oct 23, 2013 | MySQL
While integrating TokuDB into MySQL 5.6, we found that MySQL 5.6 does not support more than one XA storage engine. For example, there is an assert in the ha_recover function that fires when the total number of XA storage engines is greater than one. After disabling...
by Alexander Rubin | Oct 23, 2013 | MySQL, Percona Events, Percona Live
The upcoming Percona Live London conference, November 11-12, features quite a number of talks about the latest MySQL features and related technologies. There will be a lots of talks about the new MySQL 5.6 features: Opening keynote highlights MySQL 5.6 new features....
by Rich.Prohaska | Oct 16, 2013 | MySQL
I am developing a concurrent application that uses TokuDB to store its database. Sometimes, one of my SQL statements returns with a ‘lock wait timeout exceeded’ error. How do I identify the cause of this error? First, I need to understand a little bit...
by Tim.Callaghan | Oct 14, 2013 | MySQL
Today we released TokuDB v7.1, which includes the following important features and fixes: Added ability for users to view lock information via information_schema.tokudb_trx, information_schema.tokudb_locks, and information_schema.tokudb_lock_waits tables. Changed the...
by Zardosht.Kasheff | Oct 11, 2013 | MySQL
Since introducing TokuMX, we’ve discussed benefits that TokuMX has for existing MongoDB applications that require no changes. In this post, I introduce an extension we’ve made to the indexing API: clustering indexes, a tool that can tremendously improve query...
by Rich.Prohaska | Oct 3, 2013 | MySQL
One of our customers reported that ‘create table select from’ statements stall for a period of time equal to the TokuDB lock timeout. This indicated a lock conflict between multiple transactions. In addition, other MySQL clients that were opening...
by Peter Zaitsev | Oct 3, 2013 | Insight for DBAs, MySQL
The cost of SSDs has been dropping rapidly, and at the time of this writing, 2.5-drives have reached the 1TB capacity mark. You can actually get inexpensive drives for as little as 60 cents per GB. Even inexpensive SSDs can perform tens of thousands of IOPs and come...
by Rich.Prohaska | Sep 20, 2013 | MySQL
One of our customers sometimes observed lots of simple insertions taking far longer than expected to complete. Usually these insertions completed in milliseconds, but the insertions sometimes were taking hundreds of seconds. These stalls indicated the existence of a...
by Christian.Rober | Sep 19, 2013 | MySQL
In my last post, I discussed the existing backup solutions for MySQL. At the end I briefly discussed why the backup solutions for InnoDB do not apply to TokuDB. Now I’m going to outline the backup solution we created. Our solution works for both TokuDB and...
by Christian.Rober | Sep 12, 2013 | MySQL
There are multiple ways to backup a MySQL database. Some are more painful than others. In this two part blog we are going to discuss why the new hot backup system in TokuDB is special amidst the existing solutions. First let’s look at existing backup solutions for...
by Vadim Tkachenko | Sep 5, 2013 | Benchmarks, MySQL
This post is a continuation of my research of TokuDB’s storage engine to understand if it is suitable for timeseries workloads. While inserting LOAD DATA INFILE into an empty table shows great results for TokuDB, what’s more interesting is seeing some...
by Vadim Tkachenko | Aug 29, 2013 | Benchmarks, MySQL
I am working on a customer’s system where the requirement is to store a lot of timeseries data from different sensors. For performance reasons we are going to use SSD, and therefore there is a list of requirements for the architecture: Provide high insertion...
by Leif.Walsh | Aug 7, 2013 | MySQL
Recently, we’ve seen a few people ask us about building TokuMX from scratch. While it’s best if you just use the binaries you can get from us (they have all the right optimizations, we’ve tested them, and we can interpret coredumps they generate), we...
