I tried to come up with a number of topics for this post, but none seemed to really convey what I really feel.. And really this blog is about all of them..

• A look at PERFORMANCE_SCHEMA.STAGES and PERFORMANCE_SCHEMA.STATEMENTS
• Graphing MySQL Statement Execution
• A MySQL visual EXPLAIN plan with PERFORMANCE_SCHEMA
• Tracing Sessions with PERFORMANCE_SCHEMA

If that doesn’t whet your appetite (and trust me, I need to, this post is long, but I feel is worth reading all the way to the end), then let me start out by asking the question:

Wouldn’t you like to be able to trace what a SQL statement did, either in the same or another session, on a production instance, after the fact? Wouldn’t you like to know where all of it’s time was spent, and some statistics on what it was doing specifically?

I know, …

Almost a year ago we launched the AskMonty Knowledgebase, a home for information on MariaDB and MySQL. When we launched, only employees had access to write articles, though anyone could ask a question. This was done for technical reasons. The good news is that that has changed, with the latest version we just pushed live, anyone with an account (or an open ID) can create and edit articles.

There is only so much content we can write so we want your contributions, from completely new articles to editing and improving what we already have. If you have questions on how to get started, you can join the Maria Docs group on launchpad and ask on the mailing list. Or you can jump into the #maria channel on Freenode …

This week, Sarah's off, and Sheeri interviews Brian Aker of Data Differential, mostly about the MySQL Ecosystem.

Among the topics discussed are whether the MySQL Ecosystem has peaked yet, the exciting talks coming up at the O'Reilly MySQL Conference including the state of the community keynote, and when the Drizzle software is going GA.

Some parts of the MySQL Ecosystem that were mentioned:
phpmyadmin
Percona Server
Percona free InnoDB hot backup tool

read more

As Hakan mentioned previously, the full text of SQL-99 Complete, Really by Peter Gulutzan and Trudy Pelzer, is now in the AskMonty.org Knowledgebase. Importing the text and formatting it for the Knowledgebase was a major project and I’m glad that it’s done.

Having the full text of this book freely available is a great thing for anyone who uses SQL because the book is about the SQL-99 standard and not about any particular database implementation. They do talk about different implementations, but those sections are clearly marked as such, and serve as examples of  how some databases implement (or diverge from) the standard.

The question now is: What’s …

OpenDatabaseCamp, also known as OpenSQLCamp - http://planet.mysql.com/entry/?id=26922 will be held in Sardinia, Italy on May 6-7-8, 2011.
Google Group for OurSQLCamp: http://groups.google.com/group/opensqlcamp

Manual chapter for subqueries in MySQL - http://dev.mysql.com/doc/refman/5.1/en/subqueries.html

The WorkLog entries for “subquery” http://forge.mysql.com/worklog/search.php?t=tds&k=subquery&v=0&s=0&p=0
All are low/medium priority. out of 29 worklog items, 9 are complete, almost all are scheduled for 6.0. Of the remaining 20, 1 is in progress, 4 are …

I was happy to see the announcement yesterday from Tokutek regarding their addition of MariaDB to their list of supported platforms for the TokuDB storage engine.

One particular item in the press release caught my eye: “Our customers are choosing MariaDB more and more frequently for their most demanding database applications.” We’ve added many new features over the past year in our various 5.1 and 5.2 releases, but beyond the new goodies we’ve focused a lot of energy on removing bugs and improving performance. We’ve known for a while that MariaDB is the …

The follow-up blog post on moving your MySQL applications to CouchDB has been posted on the CouchOne blog. Part 2 digs into a bit more detail on the specifics of views, and how to perform some of the more common operations used in MySQL, such as paging and aggregation in your CouchDB view. You can read Part 2 here

I’ve started a little series on how to migrate your MySQL applications and databases over to CouchDB. Most of the process is about how you think about your data, not about the database itself, the application, or the interface to the database storage. There are some use cases for data storage that lend themselves to the CouchDB document model that provides some advantages over the table-based structure in MySQL. The first part of the series is Moving from MySQL to CouchDB: Part 1.

I’ve started a little series on how to migrate your MySQL applications and databases over to CouchDB. Most of the process is about how you think about your data, not about the database itself, the application, or the interface to the database storage. There are some use cases for data storage that lend themselves to the CouchDB document model that provides some advantages over the table-based structure in MySQL.

The first part of the series is Moving from MySQL to CouchDB: Part 1.

JavaOne Latin America 2010 (Day 1 and 0) started in an exciting way where I found a nice multi-instance cluster installation of GlassFish. More on that later but enjoyed meeting colleagues from different groups within Oracle.

I gave a presentation on "Whats New in Enterprise Java Beans 3.1" and the slides are available:

S314168 - What's New in Enterprise Java Bean Technology @ JavaOne Brazil 2010
The attendees seem to like simplified packaging (EJB-in-a-WAR and deployment descriptor-free), no-interface bean, cron-like syntax, and other features were well appreciated by the users. All other …