I started poking around with the engine inside of Samba last night. Tridge had mentioned it to me at linux.conf.au.

After some hacking of the source to get it to work in our tree, I now have:

mysql> create table a (a int) ENGINE=tdb;
Query OK, 0 rows affected (0.02 sec)

mysql> Bye
[brian@zim sql]$ !ls
ls ~/mysql-builds/example/var/test/
a.frm a.tdb t1.frm t1.MYD t1.MYI t2.frm t2.MYD t2.MYI

Shame I have a flight tomorrow or I would poke at this a bit more and see what a couple more hours would get me :)

With apologies for a brief service disruption on the main page (permissions on a cache directory), Planet MySQL has undergone a little upgrade: you can now toggle to see German feeds, and at the same time the site texts will also flip to German (a few bits of text are not yet translated, I know that).

If you happen to browse to planetmysql.de, you will also end up at the right place (de.planetmysql.org).

The infrastructure is such that we can now handle any number of languages/feeds, but let's first get the German language feeds going! You can submit yours via http://www.planetmysql.org/newfeed.php.
When we have a decent set, the next language I'll set up will probably be Spanish as there has been some demand for that and I know there are Spanish blogs about MySQL. I just want to make …

Monday Morning at the MySQL conference, Laura Thomson will be teaching a tutorial Secure Your PHP and MySQL Web Applications. Laura is an excellent presenter and has been teaching people the fine skill of building secure PHP web applications for years.

In the main program, Laura will also talk about Upgrading to PHP 5: Why and How. I've been playing with PHP 5.1 a bit myself, and I reckon it's good stuff.

Monday afternoon, my colleague Jan Kneschke will do a tutorial on New Features of MySQL 5.0 and 5.1 …

Congratulations to Giuseppe Maxia, who’s won himself an iPod Nano!

Giuseppe has been actively submitting bug reports for MySQL 5.1, plus he’s got an interesting blog (syndicated at Planet MySQL), mentioning new features that are available in MySQL 5.1. Of interest, is your performance related post on Partitioning. To add to that, your bug reports are reproducible, and simply facilitate “cut-n-paste” verification! (mysql#17894)

Giuseppe, thanks for your help and helping make MySQL 5.1 rock!

P/S: Thanks for the help on the Sakila sample database …

With the introduction of mysql 5.1, they have introduced full text plugins which allows people to write their own parsers.

Now I’m not an expert in Lucene or this new feature, but it seems that both of these products are heading for the same point, One of the benefits I have often heard touted was that lucene had better relevancy, while mysql was faster. (no I don’t have any numbers to back this up.. maybe when my Sun Fire comes I’ll try loading this up as my ‘benchmark’). So it will be interesting to actually do some experimentation to see if you could get the best of both worlds.

maybe someone can sponsor me to re-tool nutch to work with a pure mysql back-end (Brian/Zack ?? are you reading this? does MySQL want to give …

This is my first posting in my own blog. Previously I posted a few comments to my Slashdot Journal, but other than that I’m a newbie WRT blogging. I also have a German-language blog (accessible via the German-language section of the Web site, which has its own URL).

The Web site will soon be fleshed out with a lot more content. In a few weeks I’m going to a announce in greater detail my forthcoming book No Lobbyists As Such - The War over Software Patents in the European Union. I decided to start the site and this blog on a preliminary basis because, within a matter of days, I’m going to publish a position paper here in reply to the European Commission’s questionnaire on patent …

[brian@zim tdb]$ make test
mkdir -p /usr/local/bin
mkdir -p /usr/local/include
mkdir -p /usr/local/lib
mkdir -p /usr/local/lib/pkgconfig
mkdir: cannot create directory `/usr/local/lib/pkgconfig': Permission denied
make: *** [install] Error 1

Now why do I need to install your software just to run the test program?

The answer is that I should not have too.

I think I will go play Settlers now...

And yes, I am working on porting a storage engine this evening that I want to toy with.

Why is this?

Because I have a huge stack of expense reports I need to get done for mysql before I leave on Monday for a trip, and I will do almost anything I can to avoid doing my expense reports.

A few months ago, I already asked for help to make a bug reproducable and it worked great, so I'd like to try it again, to find out, why a bug occurs on some occasions, but not on others.

It's about Bug report 17204. It is about stored procedures that execute successfully when they are executed for the first time, but executing them again leads to server crashes. This happened on both MySQL 5.0.18 and 5.1.7 in both Windows and Linux.

If you have any hints, please add your comments to the bug report.

Have a look at InnoDB. Well, ok your lazy, so here’s a screen print below.
Plastered thoughout the top section is the word MySQL. It’s in the core banner blurb, there’s a logo, and even links to the MySQL Documentation. And right in the middle of all this is “Innobase OY is an Oracle Company”, with the standard Oracle Logo.

So my question would be, is this a good thing or a bad thing from a MySQL advertising perspective?
Does it help or hinder MySQL?
Does it show Oracle as being in partnership with MySQL? Is this good for MySQL to increase it’s exposure into the Oracle world?
Does inclusion of InnoDB now within Oracle traffic and links improve exposure to MySQL within search engines?

Frankly, I’m a little surprised that Oracle Legal hasn’t got onto this, I’m sure somewhere there would …

Some recent posts regarding Oracle (See Smart moves by MySQL AB and Larry Ellison still doesn’t understand open source) leads me to put in my 2 cents worth.

My background I’m sure like a lot of experienced MySQL people is in Oracle, and indeed in Ingres before that (starting in 1988). I have also worked for a number of years at Oracle Corporation. Ironically I started as their resident Ingres Specialist, in an international research project of DMS (Design & Migration Services) of re-engineering Ingres applications into an Oracle Designer Repository some 10 years ago in 1996. I of course moved into a number of other Oracle roles for clients following that. I still retain some …