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 Ryan Lowe | Nov 13, 2013 | Insight for DBAs, MySQL, Webinars
Sphinx is a free, open-source search server that integrates nicely with MySQL. It provides a fast, scalable, and pluggable search framework. The Sphinx engine possesses a variety of tools enabling you to customize how searching/indexing interacts with or becomes a...
by Mike Benshoof | Nov 12, 2013 | MySQL, Webinars
Drupal is one of the most popular open source CMS applications available – and it runs primarily on a MySQL backend. Out of the box, the schema is well tuned and indexed. However, there are some ways to tweak the default installation to get more out of the...
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 Stephane Combaudon | Oct 22, 2013 | MongoDB, MySQL
We already discussed one to one relations in MongoDB, and the main conclusion was that you should design your collections according to the most frequent access pattern. With one to many relations, this is still valid, but other factors may come into play. Let’s...
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 Peter Zaitsev | Oct 6, 2013 | Cloud, Insight for Developers, MySQL
Baron recently wrote about sending the query to the data looking at distributed systems like Cassandra. I want to take a look at more simple systems like MySQL and see how we’re doing in this space. It is obvious getting computations as closer to the data as...
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 Dave Rosenlund | Oct 2, 2013 | MySQL
Save Time & Money – Do It Right The First Time SPEAKER: Gerry Narvaja, Tokutek DATE: Tuesday, October 8th TIME: 1pm ET If you are thinking of using the leading open source database in a project, learn just how easy it is to get started with MySQL, and how...
by Alexander Rubin | Oct 1, 2013 | Insight for DBAs, Insight for Developers, MySQL, Webinars
MySQL DBAs know that integrating MySQL and a big data solution can be challenging. That’s why I invite you to join me this Wednesday (Oct. 2) at 10 a.m. Pacific time for a free webinar in which I’ll walk you through how to implement a successful big data strategy with...
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 Aurimas Mikalauskas | Sep 5, 2013 | MySQL
MySQL 5.6 has a great many new features, including, but certainly not limited to a number of performance improvements. However, besides the widely talked-about features such as InnoDB support for full text search, optimizer, performance schema improvements and GTID,...
by Fernando Ipar | Aug 9, 2013 | MySQL, Percona Software, Webinars
I’m happy to announce that the recording for my recent webinar “5 Proactive Measures to Minimize MySQL Downtime” is now available, along with the slides. They can both be found here. My webinar focused on the top 5 operational measures that prevent...
by Alexander Rubin | Aug 8, 2013 | MySQL
I will be talking about Big Data with MySQL and Hadoop at MySQL Connect 2013 (Sept. 21-22) in San Francisco as well as at Percona University at Washington, DC (September 12, 2013). Apache Hadoop is a very popular Big Data solution and we can nowadays easily integrate...
