We're opening up registration for our new training courses today.  In short: we are moving from two days to a new four-day format.  The new additions are created by:

• Splitting our current InnoDB day in half. We now have one day for DBAs, and one day just on InnoDB topics.
• A new Operations Day - covering how to maintain MySQL in production.

Our developer course has also undergone revision, and we now have more query tuning examples, and a new instrumentation chapter.

What is operations training?

Many companies split their …

Originally submitted at O’Reilly

This essential guide explains what works, what doesn’t, and most of all, what’s practical about IPv6–the next-generation Internet standard. A must-have for network administrators everywhere looking to fix their network’s scalability and management problems. Also covers other IPv6 ben…

IPv6 Network Administration

A little outdated – needs updating

By Simon Mudd from Madrid, Spain on 8/18/2010 3out of 5

Pros: Well-written, Easy to understand

Cons: Too basic

I forgot to check the date this book was published before buying it and that was a mistake. The content was pretty good but as it was written in …

I have just returned from holiday and while it’s not normal reading during some of my spare time I managed to read a couple of books on IPv6 I’d recently bought to get me up to scratch and refresh my memory on the topic.

These books are:

• Deploying IPv6 Networks, by Cisco
• Understanding IPv6, Second Edition by Microsoft

The first book is quite good, and while a little old provided a good solid background for me on the subject. A lot of the information was not relevant to my interest in setting up a networked SOHO network but that’s not really a problem. The background was interesting.

The second book was a bit of a mistake. I’d ordered it as it was a …

It was a while since I wrote the previous article, but the merging of Oracle and Sun here resulted in quite a lot of time having to be spent on attending various events and courses for legal reason (one of the reasons I prefer working for smaller companies) and together with a summer vacation spent on looking over the house, there were little time for anything else. This is the second post of three, and in the last one I will cover some optimizations that improves performance significantly.

In the previous article, an approach was outlined to handle the binary log group commit. The basic idea is to use the binary log as a ticketing system by reserving space in it for the transactions that are going to be written. …

Everybody knows that parsing the output of SHOW ENGINE INNODB STATUS is hard, especially when you want to track the information historically, or want to aggregate any of the more dynamic sections such as the TRANSACTIONS one.

Within the InnoDB plugin the INFORMATION_SCHEMA.INNODB_TRX table was added, which allowed you to at least get some of the information on each transaction, but not the full breadth of information that SHOW ENGINE INNODB STATUS provided.

“This is nice..” I thought “..but why not go the whole hog..?”.. And so I set about doing that, and opened up Bug#53336. In a very short time, I was in a review process with the …

It seems safe to say that Oracle is currently ahead of Microsoft when it comes to the company with the most contentious relationship with open source. To some extent that is due Oracle’s questionable approach to community, but it must also be noted that Microsoft has managed not to put its foot in it for a while.

In Microsoft 2009 published its first companywide perspective on open source, made its first contributions to the Linux kernel, and created the CodePlex Foundation, an independent entity designed to encourage its developers and other companies to contribute more to open source software projects.

Doubts have remained about Microsoft’s ongoing commitment, however, with the company being labeled opportunistic in its approach to open source, and skepticism persists – particularly in relation to software patents. We have recently published a new …

I’ve noticed that a steady and perhaps even growing number of bug reports and feature requests are getting resolved for the next milestone release. I continue to see signs that Oracle’s next release of MySQL will not only include much of the unreleased good work that’s been done over the last few years, but will add a lot of new features and fixes as well.

Related posts:

1. MySQL Enterprise/Community split could be renewed under Oracle
2. 50 things to know before migrating Oracle to MySQL
3. Migrating US …

This year’s Linux Plumbers Conference is taking place November 3-5, in Cambridge, MA, United States. The CfP is already closed and the program is due any day now, but the co-located miniconference on high availability clustering is still accepting proposals. This is your chance to get involved!

So if you plan to attend Plumbers or just happen to be in the area, please submit your talk! Miniconference talks are not expected to be full-blown presentations. Instead, you can float an …

FromDual launches its database Performance Monitoring solution for MySQL / MariaDB. This solution provides monitoring capabilities for most MySQL Storage Engines (Aria, InnoDB, MyISAM, NDB, PBXT and XtraDB). Further you can monitor MySQL Master - Slave replication set-ups, UNIX processes (mysqld, ndbd) and MySQL/MariaDB specific information.
More details you can find on the page Performance Monitor for MySQL.

Users of the latest builds now have a GUI way to display a detailed query profile for the executed SQL in a query tab. Just check the Query profile tree node in the newly introduced "helpers" tree and run some query.



This is basically what SHOW PROFILE in MySQL 5.0.37 and later releases does. HeidiSQL just adds colored bars and a conveniant checkbox to accomplish that.

You may also have noticed that the tree replaces a tabbed list box, which was not able to hold a 5th tab for the profile stuff without overcrowding the GUI. Converting this to a tree makes the helpers more user friendly and look more like a standard GUI for developers.