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.
…[Read more]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 …
[Read more]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.
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 …