Emergency

Monthly Archives: April 2011

Hot Column Addition and Deletion Part II: How it works

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, …

Read More
 

Optimizing slow web pages with mk-query-digest

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 …

Read More
 

Percona’s Sessions at the O’Reilly MySQL Conference and Expo

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.

Read More
 

Win free MySQL Conference Passes!

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. …

Read More
 

More on MySQL Error Messages

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 …

Read More
 

Tokutek to Speak at 2011 IOUG Collaborate 11 and O’Reilly MySQL Conference

by:

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 …

Read More
 

Upcoming webinar on Data Recovery for MySQL

I’ll be giving a 40-50 minute long webinar on 26th of April on data recovery for MySQL. Almost every long serving DBA has been faced with the task of recovering data from a database, whether …

Read More
 

Hot Indexing Part I: New Feature

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 …

Read More
 

MySQL caching methods and tips

“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 …

Read More
 

Flexviews – part 3 – improving query performance using materialized views

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 …

Read More