Pages

▼
Wednesday, May 24, 2006

Tutorial for a more powerful MySQL Sandbox

›
The MySQL Sandbox has been enhanced, with a new express installer, capable of setting up a sandbox in just a few seconds, and an interactiv...
Sunday, May 14, 2006

New homes

›
I have a new web site. I registered the datacharmer.org and datacharmer.com domains, which are now jointly my main page. (Both addresses ...
Wednesday, April 26, 2006

MySQL Community Awards

›
Second day of the MySQL USers Conference 2006. At breakfast, Arjen approached me, asking if I could hang nearby the podium during the keynot...
Tuesday, April 25, 2006

Talk at the MySQL UC: Higher Order MySQL

›
From the highly unorthodox department, a speech about stored routines that create other routines in MySQL. Higher Order MySQL at the MySQL U...
3 comments:
Friday, April 21, 2006

Advanced replication techniques in MySQL 5.x

›
OnLamp has just published an article I wrote about some interesting things you can do with MySQL 5.x and replication. You can create an ar...
1 comment:

Introducing MySQL 5 Replication Playground

›
As promised when I talked about the MySQL Sandbox and as mentioned in this (very) recent article on replication , I have released a testing...
1 comment:
Wednesday, April 19, 2006

Introducing MySQL Sandbox

›
Normal MySQL users are going through a flurry of announcements about new versions that make them salivate ath the thought of what can be don...
Sunday, April 16, 2006

SQL Easter egg

›
There is a tentative Obfuscated SQL contest with one entry by Kai Voigt. SELECT CONCAT(CONV(536,8,20), LPAD(EXPORT_SET(1,'Y','...
Sunday, April 09, 2006

Sorting data by set of keys

›
This seems to be a popular problem, since I saw it twice in the past few weeks in two different newsgroups. Somebody complains that, having ...

Dumping MySQL information schema

›
I have been invited to join the O'Reilly weblogs on databases . Today I gave my first contribution, with a piece on dumping MySQL infor...
Sunday, April 02, 2006

Measuring replication speed

›
I am writing an article about some advanced replication features (coming soon), and I wanted to measure the speed of each specific architect...
3 comments:
Thursday, March 09, 2006

Seeking alternatives to cursors

›
As users of stored procedures know, cursors can only work with explicit SQL statements, while they don't work with dynamic queries (ther...
Friday, March 03, 2006

MySQL 5.1: Improving ARCHIVE performance with partitioning

›
In a recent article ( Improving Database Performance with Partitioning ) Robin Schumacher explains how to use range partitioning, giving som...
1 comment:
Tuesday, February 28, 2006

puzzled by date functions

›
Today I was analyzing the behavior of the query optimizer, and I stumbled into a most curious case. I created two functions returning the ex...
Friday, February 17, 2006

Speaking at the 2006 MySQL Users Conference

›
Well, it came a bit late, but it's official (good thing I haven't bought a conference pass yet!) I'll be speaking at the fourth ...
1 comment:
Monday, February 13, 2006

Workshop on MySQL 5, Milan, March 2006

›
My company is organizing a workshop on MySQL 5 . It will be held in Milan, on March 24 th , and it will cover the following: MySQL 5 main n...
Friday, January 27, 2006

MySQL 5 general purpose routine library - VII: Testing and best practices

›
(Seventh part of the MySQL 5 general purpose routine library presentation.) Test units Testing is often considered a boring activity, somet...
2 comments:

MySQL 5 general purpose routine library - VI : Globals

›
(Sixth part of the MySQL 5 general purpose routine library presentation.) Among the General Puropose Routines there are some that are more ...