Recycling old MySQL business cards
Originally uploaded by Geert JM VanderkelenWell, we don't have a policy on what to do with them, so I went creative. Not as creative as Harrison did (where is that picture???), but I like it. It's hanging next to my MySQL certificates. Yes, I'm proud on these things, maybe I'm a bit vain.. But it does look good on the wall of my storage room.

(btw, this flickr to Google blogging is great!)

A bit of early Sunday morning rhymes at work.. picking up a support shift (not all you read is true: I do not hug cups!):

The struggle to wake up,
rubbing eyes and hugging the cup
Picking up the shift,
reading email and hoping for no drift
Reminders better be spam,
this morning I wish it remain calm

Oh little hangover
Why are you here
Oh little fever
It must have been the beer

Still dawn outside,
soon customers awake, and I can't hide
If it all stays online,
all will be good, I'll have a great time,
But something will have failed,
and we'll save folks badly bunkered

Oh five hours of sleep
Why wasn't it longer
Oh in bottles I looked deep
Eight hours, I hope not to linger(penned on 20th January 2008) 

Just a quick note to let you know that you can download and test the new MyISAM online backup that is part of the overall new backup utility that is shipping with MySQL 6.0.  The backup is native (not logical like a mysqldump backup) and online so you should get no interruptions in activity while the backup is running and it should be faster than logical-styled backups.  Download the preview and let the backup team know what you think.  Do keep in mind this is a preview release so you may/will find bugs.  Finally, kudos to the backup team for getting this out far ahead of the original  schedule.

I will be in Rome on May 30 to attend the meeting with Marten Mickos.
Giuseppe has posted a translation of the official announcement of the event, here.

I will be there as a member of the Community and as CTO of HoneySoftware (an Italian ISV, MySQL® Enterprise Ready Partner).

I am wondering if there will be also a meeting in the morning with customers (as Giuseppe posted) or not: the official agenda starts only at 4:30 pm.

See you there!

This is my first post on Planet MySQL® (a feed aggregator for blogs, news and opinions on MySQL®).

Latest posts you could be interested in:

1. [More on Bug #29768]: It seem that Bug #29768 has been fixed with version 5.1.24-rc 
2. [Server Monitoring]: Hit Ratios for MySQL® Server Monitoring: a SQL Script
3. [Falcon Engine]: Re: Weekly Falcon Test Overview 2008-04-25 

Other resources: …

Yesterday I had a look at the Open Source Census (OSC), a project aiming at counting the installations of open source packages.

It is a collaborative effort. The OSC offers the infrastructure, and it's open to cooperation. It works with a disc scanner, and relies on the principle that the contributions are voluntary and anonymous.
If you want to contribute, you need to register, and you are encouraged to do so anonymously. The OSC is not interested in who you are, but the registration gives you a chance of tracking your results with the rest of the community.
The registration is also necessary to avoid duplicates, and to track your installations over time, should you decide to do that on a regular basis.
If you want to give it a try, the procedure goes like this:

1. Register (with any fancy …

There were a number of problems in the installer script and in support for COMPLETE refresh materialized views. These problems have been rectified and an updated version is available on sourceforge. Also, you can pull the latest source from the svn repository:
https://flexviews.svn.sourceforge.net/svnroot/flexviews/src

Here is a little example for complete refresh:

CALL flexviews.create('mv2', 'test', 'COMPLETE', 1);
SET @MVID = LAST_INSERT_ID();
CALL flexviews.set_definition(@MVID, 'SELECT 1');
CALL flexviews.enable(@MVID);
CALL flexviews.refresh(@MVID, 'COMPLETE');

Since few weeks I was working on patching the MySQL 5.1 with libevent support to have thread pooling in server end as it is needed by few properties where they do not need a persistent connection and needed to scale server with thousands of connections as each call just does a simple query execution by connecting and disconnecting and pooling seemed to be a right choice.

When I brought this idea to Monty; he pointed me to 6.0 where it is in preliminary stage. Now I took the same design and implemented in 5.1 to be compatible with how its working in 6.0; and things so far seems to be running fine, except few misc glitches that am trying to solve now.

It uses the same thread_handling=one-thread-per-connection (default) and new thread_handling=pool_of_threads and thread_pool_size controls how many will be initialized and kept at the …

I keep on with my productivity little tricks. This time I’m sharing some of my firefox shortcuts. I’m not in the mood for explaining how to actually install these, so check out the excellent article Firefox and the art of keyword bookmarking, if you need help.

# Dictionary search
dict http://dictionary.reference.com/search?q=%s

# Yahoo finance stock
fi http://finance.yahoo.com/q?s=%s

# Wikipedia page
wp http://en.wikipedia.org/wiki/Special:Search?search=%s
slang http://www.urbandictionary.com/define.php?term=%s

# Search in MySQL website/manual
my http://mysql.com/%s

# BitTorrent search
bt …