Roland Bouman just gave me a call. He’s setting up a MySQL UDF repository, which sounds worth while joining. So I’ve decided to move the libmyxql project there. The lib will be renamed to lib_mysqludf_xql to follow the naming convention. You can find the repository on http://www.xcdsql.org/MySQL/UDF/index.html.

He also gave me a few good tips, including a way to get the name from the column or alias to be used as tagname. This should make the lib a bit more like SQL/XML. The downside is that the API will change again, but it the end it will be much better, so…
He also got his UDFs working for Windows, which I will implement as well. So good news for all you Billy lovers out there.

More about this soon….

Looks like one-time hot VOIP company Vonage has got its work cut out for it.  While the company was once considered disruptive, now it's got one foot in the grave due to mismanagement, excessive spending and a potentially fatal patent run-in with Verizon.  The company has been losing money steadily and it's stock (NYSE:VG) cratered some months back wiping out $2 billion in market cap.  The stock is trading in the single digits, now well below it's IPO price of $17.  In fact the market cap seems to be hovering just over cash-on-hand. Easy come easy go.

The company recently sacked the CEO and is now looking to …

As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions.
We rarely would use this feature as it is incompatible with our slow query analyses patch and tools
Fixing this is not trivial while staying 100% compatible to standard format as TIME type which is used to store query execution time and lock time does not store fractions of the second.

Today I've got some time to play with table based slow query log in production while tuning one of the systems. It is pretty nice to be able to work with data in SQL as it easy to filter all queries which happened within certain time interval (ie after I've done some changes) or filter out queries which you already looked at using LIKE statement.

As default table format for slow_log is CSV with no indexes …

We’ve been playing with partitioning in MySQL 5.1.18 from the MySQL AB community builds and noticed that the daemon will dump core every 5 minutes or so when under load.

Recompiling from source fixes the problem. Anyone else notice stability problems?

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!