When I first joined MySQL one of the things that was evident was the Support Engineers spent quite some time with customers issues that were focused on performance tuning. Performance tuning issues generally start with a engineer requesting a bunch of information from the customer such as:

• SHOW GLOBAL VARIABLES
• SHOW GLOBAL STATUS (a number of times, to give us some rate information)
• SHOW FULL PROCESSLIST
• SHOW INNODB STATUS (if InnoDB is widely being used)
• vmstat output for a number of short periods
• iostat -dx output for a number of short periods

A lot of this output is pretty easy to go through when you know what you are looking for. However where we spend a lot of our time is looking through the SHOW GLOBAL STATUS output - trying to piece together the rates of change etc. so that we can get more insight in to what is hurting the database.

I also …

Having discussed BLOB streaming for MySQL with a number of people I have gathered quite a bit of input on the subject.

So here are some details of the issues raised so far:

Server-side API

One of the first things that Brian Aker pointed out to me was that the server-side API must make it possible to use the sendfile() system call. The call does direct disk to network transfer and can speed up delivery of a BLOB stream significantly.

The server-side API must also include a mechanism to inform the stream enabled engine that an upload is complete. Assuming the streaming protocol used is HTTP, there are 2 ways of determining the end of a download: either the connection is closed when download is complete, or the length of the BLOB data is specified in a HTTP header.

ODBC Issues

Monty was concerned about compatibility with the MySQL ODBC driver. The …

At Red Hat's conference last week, I spotted a guy using a tiny keyboard equipped PDA that I didn't recognize.  It turns out it was the Sharp Zaurus SL-C3200, which is not available officially in the US, but is popular in Japan. Still you can buy it through the web at Dynamism and other grey market importers.

The Zaurus has gone through several iterations and form factors over the years and was the first Linux handheld shipped way back when. It now has a 6gb hard drive, SD and CF slots and a decent VGA (640x480) screen.  It's compact enough to carry in a pocket or on a belt clip and weighs just over 10 onces (298 g). With the SD slot, you can add a wi-fi card and get internet connectivity.

I don't think there's a perfect device …

Hi,

MySQL Connector/Net 5.0.7 a new version of the all-managed .NET driver for MySQL has been released.

This is a bug fix release for the current production branch of Connector/Net.

Version 5.0.7 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-6.0 Falcon "Preview".

It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

Bugs fixed

• Bug #27269 MySqlConnection.Clone does not mimic SqlConnection.Clone behavior
• Bug #27289 Transaction is not …

Mehlam Shakir, CTO of RippleTech, discusses a practical approach for auditing MySQL databases to meet security and compliance regulations. Hear real-world cases and see a live demonstration of how RippleTech’s Informant solution compliments MySQL by adding a security layer without any performance impact.

For more information on RippleTech’s INFORMANT, visit http://www.rippletech.com/

I have to say, I was a bit worried this would be a typical vendor presentation where every other word is marketing speak for how great the product is. It actually just ended up being “here’s how Informant works, and here’s how auditing, security and compliance needs can be met,” presented in a way that’s useful and valuable to anyone who is interested in auditing or security.

Rippletech’s Informant is not only interesting because it’s currently the only software that …

This release of MySQL Table Sync adds the ability to sync only part of a table, adds minor new functionality, and fixes a bug that could crash the tool.

sorry for things being so boring around here. i?ve been grinding away at bugs at work. after gaining some ground on bugs in connector/odbc, i?m being reassigned to help out with some server bugs again, at least part-time.

fixing bugs in c/odbc is an adventure. the code base bears the scars of several different developers of varying levels of cleverness and somewhat conflicting coding styles. but now that the test suite is in shape, it is easier (and safer) to do some more mechanical transformations to undo some of the damage.

one problem with tackling bugs in an odbc driver is that a lot of the reports involve third-party applications like microsoft access or crystal reports, or development tools like delphi that we don?t have as much expertise in. the initial reports often don?t include all of …

Craig announced jMaki on Rails. Here I provide detailed steps to read data from a MySQL database and display it in a jMaki-wrapped Yahoo DataTable widget.

1. Download NetBeans 6.0 M9 (Full version) and configured to install only "Base IDE", "Java IDE", "Web and Java EE" and "Ruby" modules. A cutting-edge build can be obtained from the hudson build.
2. Download and install jMaki …

As always, the digital world is evolving. Quickly. Yet, the way we store our data was envisioned decades(!) ago. To accommodate today's needs, wild solutions are tacked onto old systems. This practice is commonly known as hacking. While these solutions work great for a number of people, they share a fundamental flaw: They are hacks who pervert the original idea of the system's design and implementation.

CouchDb is designed to fulfil data storage requirements in modern times. It doesn't come with legacy to support and without hacks to make it work on current and future systems. If you are looking for ways to save, see, secure and share your data as in The four pillars of data management, CouchDb supports all of them:

• Save - Robust, ACID compliant storage engine.
• See - View engine to efficiently filter, format and organize …

This post is slightly off-topic, but I thought I'd share some information.  I've been suffering from carpal tunnels syndrome recently, and it's only gotten worse.  Apparently I'm not the only bloggers to suffer from this. And what's apparently made it worse is in my Internet/e-mail/blogging addiction, I've queued up a bunch of posts to take place over the next couple of weeks while I'm traveling.  (I may also have aggravated this by trying to play a lot of rock guitar.  Recently when I'm completely ill-equipped to do so.)

At any rate, I'm trying not to type so much.  And some of you may have already guessed that this posting is being written using voice recognition software from Dragon systems.  (Naturally speaking, version …