Open Query blog

It’s my turn to hand out a cool iPod nano again, and after another delve into our bugs database, this week’s winner is Berto van der Kraats. He has submitted a number of important bug reports for MySQL 5.0, primarily related to the optimizer. I already talked a bit about the significance of such reports [...]

Filed under: Uncategorized | by arjen
1 Comment »

Yusuf Goolamabbas asked me:
Arjen, The mysql 5.0 datasheet refers “server side thread pool” as a 5.0 feature. Could you elaborate on this in a blog post. Does this imply that solutions like sqlrelay SQL Relay are not needed for connection pooling in 5.0 ?
Here’s the post, Yusuf!
All versions of MySQL Server have a thread cache [...]

Filed under: Uncategorized | by arjen
No Comments »

Stored Procedures are a useful -but much abused- feature. Why abused? Well, sometimes it just doesn’t make any sense to put certain functionality into the database server.
A key positive is that business logic can be handled and enforced inside your RDBMS. Good! But something to also consider in the real world is the fact that [...]

Filed under: Uncategorized | by arjen
No Comments »

As you may or may not have heard, there is an ongoing election for European of the Year. And you don’t have to live in the EU to vote.
Florian Mueller (from nosoftwarepatents.com), who led the successful fight against software patents in the EU earlier this year, is one of the nominees. Wouldn’t it be great [...]

Filed under: Uncategorized | by arjen
No Comments »

OpenFest is a yearly open source event in Bulgaria. The exact dates for this year’s event are 29th and 30th of October. I believe entry is free. If you’re in Bulgaria, you want to be there!
My esteemed support colleague Alexander Keremidarski (Salle) is actively involved with it, doing talks on MySQL and such. This year [...]

Filed under: Uncategorized | by arjen
3 Comments »

It’s a tough life… I originally promised shwag like MySQL mugs for the beta challenge, then Kaj and I decided that Roland had really earned a more serious prize. Heck, the iPod nano didn’t even exist when we first announced the beta challenge!
Anyway, it appears that Roland was really looking forward to the mug, so [...]

Filed under: Uncategorized | by arjen
1 Comment »

Let me just show you this first:
mysql> USE test
mysql> CREATE TABLE con (i INT);
mysql> CREATE VIEW viewcon AS
-> SELECT * FROM test.con
-> WHERE i BETWEEN 10 AND 20
-> WITH CASCADED CHECK OPTION;
mysql> INSERT INTO viewcon VALUES [...]

Filed under: Uncategorized | by arjen
No Comments »

PortaWiki is for collecting, sharing and collaboration on portability issues that arise during software development and porting. There are entry points per topic and per platform.
The idea for this came up at AUUG 2005 in Sydney, originally by Peter Gutmann (cryptlib). People from MySQL AB and the OpenBSD / OpenSSH project immediately responded positively, so [...]

Filed under: Uncategorized | by arjen
No Comments »

Yes, finally
I have of course been playing with MySQL 5.0 features such as triggers and stored procedures for some time.
Last week at the AUUG conference I also taught a tutorial on the new 5.0 features, which was very popular both with seasoned MySQL users and “RDBMS migrants” alike. I think it’s becoming clear that [...]

Filed under: Uncategorized | by arjen
No Comments »

Of course the current contest is attracting much interest, but there was the earlier MySQL 5.0 Beta Challenge for which a winner also needs to be announced.
And the winner is… Roland Bouman. He has been very productive together with Andrew Gilfrin. But what really stood out was his Diagram of the MySQL INFORMATION_SCHEMA. I think [...]

Filed under: Uncategorized | by arjen
1 Comment »