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 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 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 Baron Schwartz | Apr 7, 2011 | MySQL, Percona Events
I just realized that we haven’t blogged a list of our sessions at the O’Reilly MySQL Conference and Expo (#mysqlconf) yet. Here is a hopefully complete list. Diagnosing and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features...
by Baron Schwartz | Apr 7, 2011 | MySQL, Percona Events
Want a free pass to the O’Reilly MySQL Conference next week in Santa Clara, California? It’s the MySQL conference, and the session lineup is awesome this year. We’ve got several free passes to give away. Post a comment here to claim your spot. First...
by Peter Zaitsev | Apr 6, 2011 | Insight for DBAs, MySQL
I wrote about MySQL Error Messages before and as you might guess I’m not very happy with quality for error messages it produces. Now I’m revisiting this subject with couple of more annoying examples I ran into during last couple of days. mysql> drop...
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 Justin Swanhart | Apr 4, 2011 | Insight for Developers, MySQL
“The least expensive query is the query you never run.” Data access is expensive for your application. It often requires CPU, network and disk access, all of which can take a lot of time. Using less computing resources, particularly in the cloud, results...
by Justin Swanhart | Apr 4, 2011 | Insight for DBAs, MySQL
Combating “data drift” In my first post in this series, I described materialized views (MVs). An MV is essentially a cached result set at one point in time. The contents of the MV will become incorrect (out of sync) when the underlying data changes. This...
by Baron Schwartz | Apr 4, 2011 | MySQL, Percona Software
Here’s the weekly review of Percona Server and XtraBackup news. Before I begin, let me briefly address a common question. We are sometimes asked about our plans in light of developments in the market such as MySQL 5.5, MariaDB, Drizzle, etc. The short answer is...
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 Fred Linhoss | Apr 4, 2011 | MySQL, Percona Software
Percona Server release 5.5.10-20.1 is now available for download. This is a release candidate for the Percona Server 5.5 series. In addition to MySQL 5.5.10 now being the base version, here are the changes that have been made since Percona Server beta release...
by Vadim Tkachenko | Apr 4, 2011 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
I mentioned problems with InnoDB flushing in a previous post. Before getting to ideas on a solution, let’s define some terms and take a look into theory. The two most important parameters for InnoDB performance are innodb_buffer_pool_size and...
by Peter Zaitsev | Apr 1, 2011 | Insight for DBAs, MySQL
Sometimes the question is put like are you looking for Performance OR Stability, which I believe is a strange way to put it. In real life systems you care both about Performance AND Stability. I would even say Stability is a not the best world here, I would day you...
by Vadim Tkachenko | Mar 31, 2011 | Benchmarks, Hardware and Storage, Insight for DBAs, MySQL
You may have seen in the last couple of weekly news posts that Baron mentioned we are working on a new adaptive flushing algorithm in InnoDB. In fact, we already have three such algorithms in Percona Server (reflex, estimate, keep_average). Why do we need one more?...
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...
