Sun Microsystems, Inc. and Zmanda, the open source leader in backup and recovery software, today announced they are partnering to deliver a comprehensive, global data backup and recovery solution for MySQL Enterprise subscribers. A 30-day trial of Zmanda Recovery Manager Enterprise Edition -- the first open-source backup and recovery solution designed specifically for MySQL™ databases -- is available now at www.mysql.com/zrm. Starting April 1, MySQL Enterprise customers will be able to purchase ZRM for MySQL directly from Sun worldwide. Zmanda and Sun have also agreed to joint-selling and co-marketing activities in support of MySQL, the world's most popular open source database software.

Typically, when choosing a composite index structure, your favorite DBA will tell you to put the most selective columns first. Now, when I tell people that I tend to get a few blank stares, so first, what does selective really mean?

It means, that for the given set of columns, the columns with the more UNIQUE values are more selective than columns with less UNIQUE values. In general, putting more selective values before less selective values in a composite index will result in faster access. This assumes however that comparison operations involve the EQUALS (=) operator.

To demonstrate selectivity:

Table
Col1  Col2
1     1
2     1
3     1

Query
select * from Table where Col1 = 1 and Col2 = 1

In this first example `Col1` is more selective than `Col2`. Think of selectivity as the number of rows that need to be read to make a comparison against a single …

As an independent consultant and trainer , I found myself doing a lot of existing code analysis and enhancement, mostly for stored procedures and ad-hoc SQL statements. I suspect a lot of people do the same thing as well, so I am really interested in learning how you do it. That’s the main purpose of this post. This post is tagged with Oracle, Sql Server, and MySQL, as the principals should be the same for all platforms.

Let me share with you how I do it. Notice that I look at table/column statistics and indexes in almost all the steps below. Therefore I purposely left them out in the discussion.

1. I always talk to the original author or the current owner of the code, asking him/her to walk me through it. I listen mostly, trying to understand why s/he writes code this way. I may ask a few questions, just to help me understand. I almost never do any lecturing at this stage. If the code is a stored procedure, I ask the author or …

A

All in Melbourne, keep the evening of Thursday, 20 March 2008, free. Why? We’re having a Meetup Mashup, right here in Melbourne, Australia. This is the Sun and MySQL tour around the world!

Details:
Date: 20th March
Time: 7.30pm
Venue: RMIT University (Swanston St)
Room: 10.08.04

Contact Tristan on 0422 501 726 for directions to the venue. (or me, at 0412 593 292 if you have any questions, etc.)

After we’re done at RMIT, discussing the recent acquisition (you’re guaranteed to see Support Engineer Gary Pendergast, and me speak, and answer questions), we’ll head over to the bar nearby, and grab some grub. Its a great opportunity to come and get your questions answered!

Are you already part of the MySQL Meetup in Melbourne? If not, check out the …

We’ve been running into a problem with one client:

SELECT COUNT(*) FROM tbl;

takes 0.25 seconds on one db, and 0.06 seconds on another.

Consistently. That’s a fourfold difference.

There aren’t any significant configuration differences (like query cache, etc.), the software versions are the same, and the table fits into memory. This has been looked at by at least 3 in-house MySQL experts, and the only thing we can determine is that it’s a hardware difference.

The table fits into memory so it’s not a disk issue, and the only other difference among the hardware is that the slower machine has Solaris virtualization in place in the form of “containers” (cpu is the same, etc). Is this something that’s known to cause issues with speed? The “tbl” in question is an InnoDB table, if that means anything. Is there something like the “speed” of RAM?

Note that Sun has already been …

I have created a MySQL Professionals Group for networking with others in the space, in the tradition of the Oracle Professionals group and the SQL Server Professionals groups that I already participate in.

This is a great way to network with other professionals in your field of work. I hope you join us.

To join, please follow this invitation link.

Paul

So, this past week I was in Montreal attending the annual PHP-Quebec conference. It was my first time up in Montreal and I have to say, it's a fun place! It was great meeting so many interesting folks and my session was jam-packed and a lot of fun.

One of the most interesting conversations at the conference was regarding PDOv2 and what, if anything, is going on with it. Lukas Smith raised the spectre of PDOv2 (after a tiny little prod from me. ) at the Database Panel discussion with me, Kitman Cheung from IBM, Kuassi Mensah from Oracle, and Bob Bernier from PostgreSQL. It seems that …

The MySQL Users Conference is coming up — April 14-17 in Santa Clara, California, USA.

This was forwarded to me from a colleague:

Are you interested in attending the 2008 MySQL Conference & Expo? I’m happy to announce that LinuxQuestions.org is able to give away one pass to the event. Visit this link for additional information. Good luck.

And I as well wish you good luck! If you would rather get a surefire deal instead of taking a chance, e-mail me and I can send you a 20% speaker’s discount code — I am speaking, so you get a discount!

We’re proud to announce that Release Candidate 1 is waiting on our Mirrors to be downloaded. More than 50 bugs were fixed and some additional improvements were incorporated into this build.  The connections drawing has been reworked. Now relationship-lines are evenly spaced along the sides of the table-figures. For SE version we also added a new relationship-notation where lines are connected directly from/to corresponding columns. DDL-Syntax of views is now parsed while editing - this also automates naming of the view-objects to the name used in DDL. Workbench-Overview-Page has been cleaned up and improved. And another SE feature - new pages for validation in SQL export plugins were added.
So please fetch our latest version and give it a try.