I created my Events to handle adding new partitions (and removing old ones) from my log table and they seem to be working.  However, today I noticed that the events ran a few hours later than they ran yesterday.  

          EVENT_TYPE: RECURRING
          EXECUTE_AT: NULL
      INTERVAL_VALUE: 1
      INTERVAL_FIELD: DAY
            SQL_MODE: 
              STARTS: 2008-02-13 05:36:21
                ENDS: NULL
              STATUS: ENABLED
       ON_COMPLETION: NOT PRESERVE
             CREATED: 2008-02-13 05:36:21
        LAST_ALTERED: 2008-02-13 05:36:21
       LAST_EXECUTED: 2008-02-14 07:32:22

My addpartition event is current date dependent: it creates a partition for tomorrow hopefully before tomorrow comes so we don't miss a partition and so my INSERTs don't get "No partition" errors.  So if it waits a few extra hours more each day, gradually it will push past midnight and screw things up. …

Thanks all for the help on getting my log_addpartition event running, dynamic SQL was just the ticket. 

I'm now focusing on writing the sister event: 'log_removepartition', which will find and purge partitions older than some time interval. The information schema comes in quite handy here, as I can query the PARTITIONS table to see all partitions.

read more

I want to create a log table in 5.1 that is partitioned by day.  I want to roll-off old data and create new partitions for each day automatically.  Without writing a script and a cronjob, it seems like this should be possible with Events.  Let's start with the table:

create table log (
    logged datetime not null,
    id int not null auto_increment,
    text varchar(256),
    PRIMARY KEY ( logged, id )
)
PARTITION BY RANGE( TO_DAYS( logged ) ) (
    PARTITION p20080206 VALUES LESS THAN (733444),
    PARTITION p20080207 VALUES LESS THAN (733445),
    PARTITION p20080208 VALUES LESS THAN (733446)
);

This seems pretty straight-forward:  I take my log entry time and convert it TO_DAYS and partition on that.  I have tomorrow's partition all ready to go, just in case I don't get around to adding it today.  Let's create an Event to do add tomorrow's partition for us automatically each day:

…

The MySQL All-Company Meeting in Orlando is now over. Many are already back at home (= back at work), and others are in transition. What a meeting!

One of the mildest surprises of the week were the name tags carrying a flag that represented the country of residence, as opposed to nationality. These matters are emotional. While I happen to like Germany, it’s not as if I were German. Teased by others for deserting my native country of Finland, I spent time retaliating at innocent fellow countrymen for their “even more foreign” flag than mine. Max Mether had a French flag. Birgitta Löfberg had a Swedish flag (OK, that’s the least foreign, but still foreign). And, for the largest distance from Finland, Mårten Mickos carried a US flag. Eminently teasable.

Also, on my initial name tag, I had the title “Sr. Director Sales Operations”. However, it turned out not to be an innovative way for …

This is a week full of changes. It’s been a wonderful week for me, meeting with so many MySQLers, telling the rest of the departments about our Community, having productive meetings, being acquired by Sun, and singing Karaoke with my colleagues from the Legal Team as well as performing drinking songs that get posted on YouTube.

The latest change came today. I’ll put my duties as VP Community Services on a spare flame, and focus on the integration of MySQL into Sun. Title unknown (as we’re still just planning the integration, not executing it), but something like “MySQL Ambassador to Sun”.

We want to take Sun by storm. My task will be to get out the message to Sun. “It’s not that I want you to filter the emails, but …”, said my boss Mårten. And as usual with sentences that start …

Part of what makes me very happy about our Sun deal is the interest Sun has expressed in learning from us. That has been evident in all the various meetings here in Orlando — be it with the founders, with the individual departments, or in front of the entire audience.

So as a way to teach Sun a first lesson, I had prepared a gig for the end of the presentations during the morning. We have a tradition of singing songs in our company, stemming from our Scandinavian heritage. “We take this very seriously”, I had heard Rich Green comment. And I’m happy he meant it in a very respectful manner: Corporate culture is important. Drinking songs themselves are meant to be purely fun, and not taken seriously, although they are surrounded by plenty of fairly rigid tradition.

In order to make it light for our future colleagues from Sun, as well as our own recent recruits as well as others unfortunate enough not to know …

Giuseppe Maxia had a stop-over yesterday on his way to the MySQL Staff Meeting. We met for community discussions, and rounded off with Weißbier and dinner in Munich’s famous Hofbräuhaus.

What a fantastic feeling! The Bavarian spirit of joy and happiness has been decoupled from tobacco stench! I’ve always liked the first and hated the second.

So the German non-smoker protection legislation of 1 January 2008 is good news for anyone considering arranging meetings in Germany. You will no longer be “welcomed” at the airport by an offensive smell. Headaches in German …

One week to go! Then we’ll have MySQL AB?s biggest internal meeting ever, with some 400 MySQLers being shipped to Orlando, Florida.

Almost four years ago in 2004, the company met in Cancún, Mexico. A year before that in 2003, we met in Budapest, Hungary. In 2002, we met in St Petersburg, Russia. In 2001, we met in Helsinki, Finland. In 2000, they (I wasn’t on board at that time) met in Monterey, USA. As we met last time in Cancún, we were fewer people in the whole company than last September at the Developer Mtg in Heidelberg, Germany.

I’m looking forward to meeting with all my fellow MySQLers. Besides all the working and catching-up, I expect to do some running with fellow MySQLers, share some photographs, and just enjoy spending face-to-face time.

Right now, I’m preparing for …

The 2008 MySQL Conference & Expo registration is opened!

Time flies. We’re already at our sixth Users Conference! Looking at the announcement:

Co-presented by MySQL AB and O’Reilly Media, the conference will take place April 14-17, 2008, in Santa Clara, California. The event is expected to bring together over 1,600 open source and database users from some of the most exciting and fastest-growing companies in the world, as well as from the large and active MySQL Community. The program for 2008 will include keynote presentations by Jacek Becla of Stanford Linear Accelerator and MySQL CEO Marten Mickos.

Jay Pipes, our Program Chair, has lead a huge effort in identifying the best out of the near-300 proposals for sessions. …

I will present a session on Testing PHP/MySQL Applications with PHPUnit/DbUnit at the MySQL Conference & Expo 2008 that is held April 14-17 2008 in Santa Clara, CA, US.Testing PHP/MySQL Applications with PHPUnit/DbUnit
In the last decade, PHP has developed from a niche language for adding dynamic functionality to small websites to a powerful tool making strong inroads into large-scale Web systems. Critical business logic like this needs to work correctly. But how do you ensure that it does? You test it, of course.

To make code testing viable, good tool support is needed. This is where PHPUnit comes into …