This is #2 in a series of blog postings about MySQL Performance Schema.

My colleague Mark Leith has shown some examples of output from two PERFORMANCE_SCHEMA summary tables on his blog http://www.markleith.co.uk/?p=112. I know we’ll be hearing more from him and I notice he’ll be giving a talk at our User Conference in April, so watch that space.

The specification of WL#2360 Performance Schema is now visible on our forge site http://forge.mysql.com/worklog/task.php?id=2360. I recommend you go there, click on “High Level Architecture”, read it, then come back to here. It should take you a while because this is the second-largest MySQL worklog-task specification since time began (the largest was WL#148 for foreign keys, http://forge.mysql.com/worklog/task.php?id=148). I’m an architect so I did the original specification and most of the wrangling/wheedling/editing over the last four years to keep this target in our sights. …

MySQL founder leaves Sun, Google teams up on white spaces, Lenovo looks back home, and more.

[inline:nagios-pic.png] Tag1 offers hosted Nagios monitoring, tuned for database servers. We offer monitoring of not just uptime and disk space, but MySQL performance metrics, such as InnoDB Buffer Pool Hitrate and MyISAM Index Usage. Our Nagios instance can not only notify you of service impacting problems, but of performance issues and signs that a service failure maybe coming in the future. We like to think of this as preventative monitoring.

read more

So as I mentioned earlier I am seeing some rather odd behavior when I testing Waffle Grid and really fast interconnects.  In a nutshell, with faster access to pages it appears innodb does not need to throw items out of the buffer pool as often.  Test after test shows with Dolphin Fast interconnects I get outstanding performance, but they end up putting less into memcached ( LRU’s blocks ).  The same tests performed over and over on 1gbe, get a fraction of the performance but put 3x the data to memcached.  Looking at the numbers the fast interconnect tests all share a lower number of read aheads then the 1gbe test.   I was really leaning towards the read-ahead as the culprit.  So I commented out the read-ahead.  The result.  The same.  The 1gbe is now faster then before, but the dolphin interconnect tests still blow it out of the water, …

I will be at FOSDEM - Free and Open Source Software Developers’ European Meeting - in Brussels, tomorrow Saturday 02/07 and the day after.

This year MySQL™ has a Project Stand and a Developer Room, with many interesting talks scheduled.

For me, that’s a nice occasion to meet the European part of the MySQL™ Community Team as well as other SUN™ employees and developers.

Here’s a Google map of my way to Brussels:

…

All change at Sun. A new CEO at Zend. Ingres enjoys revenue up 32%. Purple Labs raises funding. Is open source a danger to Microsoft or will Danger bring open source to Microsoft? (Not) open source food. And more.

It’s a good week for business card printers
There was a rush of new appointment and departure announcements this week. As already noted today, Sun has confirmed the departure of Marten Mickos as Sun is combining its Software Infrastructure organization with its Database Group to form a unified open source product group under the leadership of Karen Tegan Padir, vice president of MySQL & Software Infrastructure.

Earlier in the week Monty Widenius confirmed that he has left Sun, along with …

Welcome to the 134th edition of Log Buffer, the weekly review of database blogs. There’s no time to lose, so let’s begin—with MySQL.

The big news this week, the epoch-shattering event, is of course, Monty Widenius’s departure from Sun, his time to move on. Perhaps not much of a surprise, given his famously underwhelmed response to 5.1’s GA release.

But Monty, your thunder has been stolen! MySQL boss Marten Mickos is leaving Sun too. So says Matthew Aslett on 451 CAOS …

Barclays Global Investors becomes a 3.18 percent stakeholder in the struggling company, just as Sun loses Marten Mickos, the longtime CEO of MySQL.

So far this year I’ve been totally silent about the MySQL Conference and Expo 2009. In the past I’ve been a vocal advocate of going to the conference and sending your employees to the conference. So my silence was conspicuous to me, if not to you. I’ve always considered myself a strong [...]

If you followed the recent blog posts by Matt, you have noticed the nice performance. This confirms that the Wafflegrid concept is a good one and we need to continue its development and improve it.

You have also probably noticed there has been no recent WaffleGrid release, the reason is that we were thinking about how to distribute WaffleGrid. The current “patch” like approach is, let’s say, pretty poor. Another approach would be to work on the whole tree of MySQL or Drizzle but then, it would be pretty hard for someone to use InnoDB and WaffleGrid at the same time, not ideal either.

Hey…. MySQL has a plugin interface for storage engines, why not just add a WaffleGrid storage engine. It would be much easier to add WaffleGrid to MySQL and Drizzle and we would also be far less impacted by new releases of the databases. So, the next release will be a branch of InnoDB plugin and from there, integrating to Drizzle will be also …