After intense antitrust investigation focused on the MySQL database, the European Commission gives an official OK for Oracle to acquire Sun Microsystems.

Introduction

This paper is an introduction to the new 'performance schema' feature, which will be part of the upcoming MySQL 5.5 release. Covering in details every part of the performance schema would require much, much more than a simple article. The pace of this teaser is voluntarily fast, to have a quick overview of the new landscape, and help users already familiar with MySQL to understand by examples what the performance schema provides.

Please refer to the online documentation in the MySQL manual for more content.

Basic setup

Let's start a server, and a client connection for monitoring.

mysql> select version();
+---------------------+
| version()           |
+---------------------+
| 5.5.99-m3-debug-log |
+---------------------+
1 row in set (0.00 sec)

mysql> prompt Monitor> ;
PROMPT set to 'Monitor> ' …

Welcome!

I write about the techne that is the amazing machine we call "The Net".

At present, I am mostly interested in Memcached, the Drizzle DB fork of MySQL, NoSQL, and in open standards, but I will be writing about other stuff as well.

I used to do my public geek blogging in my personal LiveJournal, but for various reasons it makes sense to separate my public writings about technology, my other public writings, and writings that are of interest only to my closer friends and family.

My day job title is "Director of Community Development" for Gear6, which means that my main paid interest is memcached and the memcached community.  I read and write technical articles, research nosql databases and other web-scale open source software, and go to conferences to attend and to speak.

Any good piece of infrastructure software should be able to pop up little windows on your desktop. :)

Yesterday at LCA in Stewart's Hacking Drizzle talk, it occurred to me that error messages should pop up little windows on my desktop. So I wrote an error message plugin which uses libnotifymm to send Gnome pop-up window messages.

I don't always get to post screenshots, so here you go:

We are proud to announce the 4th public Beta of MySQL Workbench 5.2.

We want to thank all the people who have been testing MySQL Workbench 5.2 alphas and betas and taking the time to file bugs and provide valuable feedback. We have fixed many bugs since last release and worked on some other details as well. Also, there is new platform included with this beta – CentOS 5.4 Linux Packages (RPMs)
NOTE: We have a known issue with Centos SSH Tunnel support that we are working on so avoid that for now.

This build includes fixes for 65 bugs – 7 P1, 26 P2 and 32 P3.

MySQL Workbench 5.2 Beta 3 provides:

1. Data Modeling
2. Query (upgrade from MySQL Query Browser)
3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a …

We recently released XtraDB-9, and while we did not highlight it in announcement, the release-making feature is ability to save and restore InnoDB buffer pool.
The idea is not new and was originally developed by Jeremy Cole (sorry, I do not have the link on hands) some time ago, and now we implemented it in XtraDB.

Why would we need to save and restore content of buffer pool ?
There are several reasons.
First, it's not rate on modern servers to have 32GB+ of RAM, with allocated InnoDB buffer_pool 26GB or more. When you do restart of server, it may take long time to populate cache with useful data before you can bring it back to serve production load. It's not rare to see
maintenance cycle takes two or more hours, mainly because the slave need to catchup with master …

After a discussion with my colleague Stephane Varoqui we decided to see how Gearman and the NDBAPI could be used together. The result of the POC was a Gearman worker and a couple of clients (clients and workers use Google Protocol Buffers as the protocol). The worker can:

• set/get/delete records on a single table in MySQL Cluster using the primary key
• set/get/delete "any" type. It is not possible to dynamically add types but this is done at compile time.
  
• supports the following SQL data types: (UNSIGNED) INTEGER, (UNSIGNED) BIGINT, CHAR, VARCHAR/VARBINARY
• supports the following Google Protocol Buffer …

Some new features in myterm, extensible mysql command line client:TailEver found yourself running the same query over and over again to see if a table has got new content, just waiting for that magic row to appear? The tail command will watch for new lines in a table, just like you might tail a log file in Linux. Example:

1. myterm> tail -f bid
2. +--------+---------+-----------+--------+---------------------+
3. | bid_id | item_id | bidder_id | price | created |
4. +--------+---------+-----------+--------+---------------------+
5. | 67925 | 107751 | 81594 | 92500 | 2010-01-20 19:12:58 |
6. | 67926 | 34248 | 32530 | 10000 | 2010-01-20 19:12:59 |
7. | 67927 | 111211 | 108032 | 22900 | 2010-01-20 19:12:59 |
8. | 67928 | 116016 | 46720 | 90400 | 2010-01-20 19:13:00 |
9. | 67929 | 129101 | …

My talk on 10x performance improvements – A case study has just been approved for the 2010 MySQL Conference. This will be my 5th straight year speaking at the MySQL conferences. For those in Europe wanting a sneak peek I am also speaking at FOSDEM 2010 in Brussels on Feb 7th where I’ll be giving an abridged version.

As an independent MySQL consultant, my work generally covers performance tuning and scalability and sometimes database architecture. Often however my work involves a review of a given problem and recommendations (immediate, short and long term). I’m rarely involved in the full implementation and generally do not see the full fruits of the proposed work.

Recently however I was able to work with a client, first in resolving …

In my previous post “InnoDB : Why not use the same isolation level as ORACLE” I suggested that like ORACLE it might now be a good idea to use READ COMMITTED as the default isolation level for InnoDB.

Marc Callaghan made interesting measures that illustrate a case where READ COMMITTED mode degraded performance. (“Repeatable read [...]