Introduction

MySQL Server (starting from v 5.0), as Oracle and SQL Servers, allows creating stored procedures and functions.

Stored procedures are a set of SQL commands that can be compiled and stored on the server. Thus instead of storing a frequently-used query, we can refer to a corresponding stored procedure. This provides better performance (as this query is analyzed only once) and reduction of traffic between client and server.

While developing business logic of procedures, we often use a great number of variables (e.g., temporary outputs) to store. To assign static values to a variable or values of other variables, SET operator is used. SET operator in stored procedures is an extended version of usual SET …

I reported a bug about SHOW BINLOG EVENTS not working with relay logs a couple of years ago - Bug #28777.

It’s now been fixed in MySQL 5.4, by adding a new SHOW statement - SHOW RELAYLOG EVENTS.

The replication team are really hammering through things at the moment - Kudos!

this is source code for a tiny program I just wrote that traverses specified directories and removes them from file system cache.

There are few use cases for it. One is for all these people who benchmark stuff and want selective OS cache purges, another is for those who run high performance databases. Remember the O_DIRECT serialization everywhere? Well, XFS does direct I/O in parallel, unless there are cached pages (and they can happen because of any random outside-of-database activity, like ‘file’ command). Once you ‘uncache’ the files, XFS will be very much parallel again \o/ \o/

Reanimating the Sydney MySQL User Group!

What: Sydney MySQL User Group meetup #7 - The Reboot

When: July 16, 2009 5:30 PM (please don’t forget to RSVP yes/no/maybe)

Where: Sydney, CBD - join the meetup for exact location.

We are back! After 3 years of being silent, SMUG (can I call it so? I know there are conflicts with other acronyms) resurrects the meetings.

The logistic of the meetup is the following:

• 5:30pm — the gathering starts and we have pizza and beers and talking …

A new version of the DRBD User’s Guide is up at http://www.drbd.org/users-guide. As this version has some major additions to the previous release, I’ve decided to create a release
candidate this time, before declaring this an “official reference” — everyone’s feedback is requested and highly encouraged.

What’s new is Chapter 8, “Integrating DRBD with Pacemaker clusters“. It deals with the new drbd OCF resource agent we are about to release with 8.3.2, and how to use it in Pacemaker clusters using the CRM shell. It also has setup examples for MySQL, as does the legacy chapter on Heartbeat. Please grab the 8.3.2rc2 tarball if you are …

A special extended edition of Tech Messages for 2009-06-16 through 2009-06-25:

• MySQL – Restoring a Single Table from a Huge mysqldump File
  This is is hugely helpful if you don't want to restore a 25GB dump file just to grab one table.
• MCS-7828-H3: Hard Drive Errors Cause Service Outage; Hard Drive Firmware Upgrade Required
  Certain Seagate hard drive models used in HP servers (listed in the Products Affected section of this document) that are configured with firmware versions prior to HPG6 might experience drive failure indications.
• Least …

The call for papers for OSDC 2009 is open until 30 June 2009; yes that’s only a few more days. Submit your abstract and do a talk at this fab conference!

This is a grassroots style conference designed by developers for developers.  It covers Perl, Python, Ruby/Rails, PHP, Java/Grails and Open Source operating systems as well as some business aspects.  If you’d like to cover something else as well that is Open Source themed, please feel free.

The Call for Papers can be found at: http://2009.osdc.com.au/call-for-papers
The important dates are:

• Call for Papers Closes      30 June, 2009
• Proposal acceptance         20 July, 2009
• Accepted paper submissions  14 September, 2009
• OSDC 2009 Main …

When I joined MySQL back in June of 2005, one of the first “MySQL Truths” I learned and repeated often when discussing MySQL with others was “release early, release often.” If you’ve been using MySQL for any length of time, you know what that statement means – it meant that MySQL was: (1) dedicated to getting new features and enhancements into the hands of its community so the software’s quality could be validated; (2) eager to take early feedback on those features so the input could rapidly be incorporated back into the product allowing everyone to benefit; (3) committed to very frequent releases of the software so helpful new features and/or external contributions that were ready for action could quickly be put into play and not sit idle on the shelf. And if you’ve been around Open Source for a while now, you know this is the spirit in which most providers of Open Source software operate.

Currently there are several MySQL versions released by SUN. Latest version marked as stable is MySQL 5.1. This version is in build service for some time already and you may noticed that it is on it's way to Factory (no yet there, but working on it). Other newer releases are 5.4 and 6.0. 5.4 is currently in beta stage and date of stable release should be announced later this year. 6.0 is in alpha stage and it might take quite some time till it will be released as stable.

So what? Well, recently I mentioned splitting server: database repository and creating UNSTABLE branch. One reason to do this was to provide a place where experimental version of MySQL can live. And so I packaged 5.4 and it is now available in server: database: …

Where are you going to invest your time and money. You may invest in your kids, your work, your hobbies, and more. As you make these decisions, your passion is one consideration, but another is the return on your investment. Of course, you want your investments to be successful. The best way to ensure success is to bet on winners. In other words, you want to invest your time and money on things you are confident will be successful. This holds true in your personal and your professional life.

When Alexandre Dumas (on a side note, my wife refers to me regularly as a Dumas) said that "Nothing succeeds like success" he was encapsulating this same decision process and the conclusion that people want to bet on winners, and that by so doing, they are perpetuating that winning.

So what does this have to do with open source software (OSS)? I received a note from Roland Bouman about a prior post, where he said: "I got seriously involved in …