Woooo, just wrapped up another night of #DBHangOps, check out the video:

For those of you who aren’t familiar with this awesome series of videos, it’s a bi-weekly meeting of MySQL DBAs via a Google Hangout to simply talk about databases (specifically MySQL). The discussions range anywhere from silly stories to awesome learnings and even little gotchas to know about when working with MySQL operationally. If you’re interested in catching when the next #DBHangops will happen, check MySQL planet for a blog post about it, or check this twitter search.

We look forward to talking with you!

I’ve noted previously that the new transportable tablespaces for InnoDB in MySQL 5.6 are a big step forward, and newly-released 5.6.9-rc makes importing tablespaces a bit easier.  In previous versions, you had to have a .cfg file to import the InnoDB tablespace.  That file is produced during FLUSH TABLE <tbl> FOR EXPORT operations, and contains InnoDB metadata that’s not contained in the .ibd tablespace file itself.  I filed a feature request requesting the .cfg file be made optional, and Sunny implemented it:

mysql> create table tt (a INT PRIMARY KEY, b VARCHAR(10), KEY(b)) ENGINE = InnoDB;
Query OK, 0 rows affected (0.33 sec)

mysql> …

The MySQL Plugin API is a neat way to add functionality to the MySQL server. Any user of MySQL is using it: see the storage engine plugins listed by SHOW PLUGINS. There are many types of plugins. For example, the do-whatever-you-want daemon plugins. Among the hottest things that appeared lately are plugins that add new interfaces to MySQL, such as the Memcache plugin of MySQL 5.6.

In my previous post, I shared my finding that MySQL 5.6.7 does not make a cost-based choice between Materialization and IN-to-EXISTS strategies for subqueries.

It turns out I was wrong. As Guilhem Bichot has blogged here, he has implemented cost-based choice between Materialization and IN->EXISTS in MySQL 5.6.7. Igor Babaev also wrote about the topic, and covered the reasons I didn’t see the feature - it isn’t mentioned in the documentation, development process at Oracle is quite closed, and the feature didn’t work for a basic example that I have tried.

Let’s try to focus on the technical part of it. Looking at the source code, I see that …

Today there was the 'Scale with MySQL' event in the new Oracle building in Utrecht. There were sessions about the MySQL 5.6 RC and about MySQL Cluster. It was nice to meet so many other MySQL users. It was interesting too hear about what MySQL is used for and in which kind of environments.

Visit the MySQL Events page to see all other location for the 'Scale with MySQL' sessions.

And there are more options for meeting other MySQL users in the Netherlands: The first meetup for the MySQL User Group NL is on Friday November 16th.

The Internet Summit seems to be the largest Tech event of the year in Raleigh,NC area. I’ve attended this conference last year and I’m proud to be a speaker this time around. If you’re up for early morning talks I’m part of “Tech Track: Inside the Data Center” block of sessions, starting at 8am, where I will talk about challenges of using MySQL in the data center.

I’ll be on the show for the full day tomorrow so feel free to drop me email if you’re attending if you’d like to catch up for business or pleasure.

Industry Leading Database Analyst Matt Aslett, MySQL Pioneer Doron Levari and Industry Veteran Paul Campaniello Host Webinar on The New World Order of NoSQL, NewSQL & MySQL BOSTON – November 7, 2012 — Picking the wrong database can result in slow performance or downtime, frustrated customers and lost revenue.  But navigating the new world order of [...] Read More

Woooo, just wrapped up another night of #DBHangOps, check out the video:

For those of you who aren't familiar with this awesome series of videos, it's a bi-weekly meeting of MySQL DBAs via a Google Hangout to simply talk about databases (specifically MySQL). The discussions range anywhere from silly stories to awesome learnings and even little gotchas to know about when working with MySQL operationally. If you're interested in catching when the next #DBHangops will happen, check MySQL planet for a blog post about it, or check this twitter search.

We look forward to talking with you!

Wednesday, 11/28 @ 10 am PT/ 1 pm ET Register at http://www.percona.com/webinars/industrial-strength-mysql-applications-using-percona-and-continuent

MySQL is the first choice for a large majority of web applications thanks to its ease of use and low cost of operation. However, running big apps on MySQL is still a challenge even for experts. In this webinar we will show you how to combine

First I wanted to thanks all the attendees and for the nice comments I got.
As promised during the webinar, these are the answers of the questions you asked.

Q: Does Percona provide plugin for cacti?

A: Yes we do. They are part of Percona Monitoring Plugins. You can see some examples here.

Q: What if replication is running legging on production?

A: The point when I say that you don’t want to receive alerts if replication is lagging on a slave used for backup for example is to explain that with alerting solutions, you need to filter the alerts. You need to reduce them to the minimum possible alerts that are critical for your production. …