How can a query like “SELECT * FROM tbl WHERE col IS NULL” return a row where the column has a (non-NULL) value? Read on to find out. First, a demonstration Try this one yourself: create table test( a int not null auto_increment, b int not null, primary key (a) ); insert into test(a, b) values (0, 1); select * from test where a is null; +---+---+ | a | b | +---+---+ | 1 | 1 | +---+---+ Your reaction might be, as mine was, “what the heck is going on here?

We are happy to announce that we have now enabled interim snapshots for Connector/Net 5.1.  It can be found at http://downloads.mysql.com/snapshots.php.

These will not currently update nightly.  In the future, we hope to enable nightly uploads of snapshots.  In the meantime, please take care when using these builds.  They are snapshots directly out of our development trees and are not guaranteed to function at all.  They are intended simply to give users and customers an advance look at what is coming in future released versions.
Thanks!

ZRM for MySQL Cluster Edition, released during MySQL users conference last month, provides non-blocking backup and recovery for MySQL cluster databases. In addition to backup and recovery for MySQL clusters, the cluster edition also supports online backup and recovery of other MySQL storage engines such as MyISAM, InnoDB. Most applications using MySQL Clusters also store data in other storage engines. The Cluster edition provides a common user interface for backing and recovering applications that use multiple MySQL storage engines.

ZRM for MySQL supports both MySQL Cluster as well as the MySQL Cluster Carrier Grade edition.

Hej hej from Stockholm where I arrived about two weeks ago for a fun-filled two four six weeks of meetings and face-to-face contact with the MySQL Cluster developers. And the chance to check things out when it’s not 2°C and raining, all the time, as it was when I was here in November and December of 2005. (This week, it’s 12°C and kind of misty.)

The last five or six weeks have been pretty hectic, and this evening (it’s just after 10 PM local time as I write this) represents the first time in that span that I’ve actually had time that’s not been planned out for me in one way or another. At the end of April, I moved out of my place in Brisbane and stuffed all my gear into storage in Coffs Harbour, New South Wales, where I rented a post office box that now constitutes my sole legal address for the duration.

That last sentence is actually …

We are happy to announce that we have now enabled interim snapshots for Connector/Net 5.1.  It can be found at http://downloads.mysql.com/snapshots.php.

These will not currently update nightly.  In the future, we hope to enable nightly uploads of snapshots.  In the meantime, please take care when using these builds.  They are snapshots directly out of our development trees and are not guaranteed to function at all.  They are intended simply to give users and customers an advance look at what is coming in future released versions.
Thanks!

So you have followed the recipes to create a standby database, setup the database to switch logs automatically, and now, as with any good database, the space required to support the application grows and grows and grows. Eventually, using your monitoring software (in my case, Pythian’s avail or dailies), you get an alert suggesting that you [...]

Interface21, the company behind the Spring framework for Java has raised $10 million in venture capital from Benchmark Capital.  Benchmark is one of the leading VC firms in Silicon Valley and has invested widely in open source companies including MySQL, Red Hat, Collab.net, Terracotta, Zimbra.

Benchmark partner Peter Fenton was also named one of the top VC's under 40, along with Danny Rimer from Index Ventures, another regular open source investor.

• Interface21: Company, …

This is an example of running two connections in a single test case and I will go step by step through the test case with explanation.

Create the File
In the MySQL source directory you will find a mysql-test directory where the test files and executables used in this tutorial will be found. We will be creating a test case called cfoo.test in the mysql-test/t/ directory where all test cases are stored.

Import Include Files
Like using libraries in C++, the *.inc files found in mysql-test/include help save time in writing code used by multiple tests. In this test we will be using the InnoDB engine so I included have_innodb.inc.

-- source include/have_innodb.inc

Clean Tables Needed for Test
Previous tests may have used the table needed in the test so we remove it.

--disable_warnings …

1. Download and install BitKeeper. There is a guide here explaining how to download and install it.
2. Using BitKeeper the execute the command:
   

       bkf clone bk://mysql.bkbits.net/mysql-5.1 mysql-5.1

   to download the latest MySQL 5.1 source tree to directory "mysql-5.1".
3. Change directories into "mysql-5.1" and run: BUILD/compile-pentium-gcov

4. If you encounter any errors in the build process my previous post has a list of a dependencies that cause a few common compilation errors.
5. To run the test suite run: make test-force-full
6. Download lcov from http://sourceforge.net/project/showfiles.php?group_id=3382
…

I realized when I released my very crappy version of My ?hourly? MySQL monitor script I really should have included my standard logging.

So I did that the night I wrote my original blog, but never published it. I’ve had need to use it again today, so a few more usability tweaks for parameterization and we are good to go.

Now Version 0.03 includes three files:

• hourly.sh
• common.sh
• mysql.conf

Simple use is:

$ cd /directory
$ vi mysql.conf
# correctly specify MYSQL_AUTHENTICATION
$ chmod +x ./hourly.sh
$ nohup hourly.sh &

This gives you the following files

-rw-r--r-- 1 rbradford rbradford  2643 2007-05-29 15:47 mysql.innodbstatus.070529.154757.log
-rw-r--r-- 1 rbradford rbradford   414 2007-05-29 15:47 …