Update: Dynamic Materialized Views
Please read this article also. Its an improved versio of the technique described below.

Today i found a workaround for a feature that was realy missing in MySQL.
Let's say you got a really complicated query that requires a lot of cpu and time to complete, but the resulting data is quite static. That's the perfect opportunity to use a "Materialized View". The Bad Thing™ is, mysql does not support what's usually known as materialized views. But today i found a nice workaround for MySQL 5.
But first let's clarify what a materialized view is. I found a good explanation here:
"A materialized view is a stored summary containing precomputes results (originating from an SQL …

Microsoft has taken pity on those of us who couldn't make it to the PDC this year and posted all the sessions online complete with speaker video and slides.  I watched the Monad presentation yesterday and was blown away.  It will take me some time to work my way through all these videos so I am basically posting this here as a reminder to myself.

Here is the link.

I posted the source to my replication monitor (rep_mon.pl) over at sourceforge, along with a screen shot of it in action. It doesn't look all that fancy, but when you've got a dozen MySQL servers, it sure helps to have one script that checks them all at once!

It may be tested again! Just a few days we released our last beta, a new version of MySQL got published: The long awaited MySQL 5!

For Linux we can offer now a refurbished beta version containing MySQL 5. A appropriate Windows beta follows soon.

Go to XAMPP BETA download area

It may be tested again! Just a few days we released our last beta, a new version of MySQL got published: The long awaited MySQL 5!

For Linux we can offer now a refurbished beta version containing MySQL 5. A appropriate Windows beta follows soon.

Go to XAMPP BETA download area

PortaWiki is going pretty well. We’ve got a couple of contribututors at the moment and getting good little bits on the various oddities of various platforms. I encourage you to check it out and add things that you know.

It’d be great to have a MySQL section there too. In versions previous to 5.0 for example, you may get different results from some math operations on different platforms as we used the floating point stuff. In 5.0 we have precision math so this isn’t a problem - but it probably caused somebody to raise an eyebrow in the past. Volunteers?

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 if he became the winner?

You can vote directly, however you do need to vote in all 10 categories. If you would like some recommendations and background info based on position/trackrecord (particularly when it comes to software patents), take a look here.



Don't underestimate the power of our huge community.
Let's, together, make Florian Mueller European of the Year! …

I was trying to come up something funny|cute that used new features in 5.0 and settled on a quick little bit with a coffee pot and mug:

create table pot (coffee int unsigned);
create table mug (coffee int unsigned);

delimiter |

create trigger pour_cup after delete on pot
        for each row begin
                insert into mug (coffee) values (1);
        end
|

delimiter ;

Try it out:

mysql> insert into pot values (1), (1), (1), (1);
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from pot;
+--------+
| coffee |
+--------+
|      1 |
|      1 |
|      1 |
|      1 |
+--------+
4 rows in set (0.00 sec)

mysql> select * from mug;
Empty set (0.00 sec)

mysql> delete from pot limit 1;
Query OK, 1 row affected (0.00 sec)

mysql> select * from mug;
+--------+
| coffee |
+--------+
|      1 |
+--------+
1 row in set (0.00 sec)

Whenever someone deletes coffee from the pot it …

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 we're also sponsors.

Yesyes, the OpenFest site is in Bulgarian. Go learn your Cyrillic! ;-) Did you know that the inventors of the Cyrillic alphabet were actually Bulgarian, not Russian?