I actually received this book about a month ago but from necessity, I had to put it to one side and deal with more important issues. It is not a big book, only 235 pages, but it has an easy to read conversational style, unlike similarly titled technical books on the internals of other software.

If you're looking for a book about database theory, this book is not for you. It conveys to the reader a good overview as how MySQL functions without delving into the theories as to how the algorithms work or the rationale behind their design. The book does a good job of at least giving a drive-by look at most of the significant components of MySQL. libmysys, MySQL's platform library which allows MySQL to work on a very wide range of operating systems is mentioned only under the subsection titles 'Core API' and 'Utility API' and only lists about 30 of the functions available: libmysys provides the important glue between MySQL and the operating …

Google launches open source gears project. Novell reports quarterly earnings. Covalent expands open source support offerings. (and more)

Google Launches Gears Open Source Project to Bring Offline Capabilities to Web Applications, Google (Press Release)

Novell Reports Financial Results for Second Fiscal Quarter 2007, Novell (Press Release)

Covalent Technologies Continues Expansion of Open Source Support Offerings, Covalent Technologies (Press Release)

CollabNet …

So, this is me:

Special thanx to Colin Charles for taking the picture and linking to it from his blog.

Notice that in addition to my photogenic qualities as well as the bags under my eyes, that I’m wearing an incredibly geeky necklace.

Yes, it’s true. I bought a white gold dolphin to wear around my neck, because I am THAT much of a MySQL geek.

In this episode we tackle what a hash looks like in terms of a data structure, in preparation for next episode’s discussion on the difference between hashes and btree indexes, and what kind of indexes are good for what kind of optimizations.

Show Notes:
Direct play this episode at:
http://tinyurl.com/33wuff

Download all podcasts at:
http://technocation.org/podcasts/oursql/

Subscribe to the podcast at:
http://feeds.feedburner.com/oursql

News:
MySQL Connector/NET 5.1.1 released:
http://tinyurl.com/23a9ax

Download the new Connector/NET version:
…

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 [...]