Pages

▼
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 ...
Sunday, January 08, 2006

Checking MySQL weak passwords

›
Do you have a policy of strong passwords? Do you want to enforce it? If yes, then you may want a quick way of checking if your users are abi...
2 comments:
Saturday, December 31, 2005

New Year quiz

›
A few days ago I was asked to analyze some data related to a particular service usage in a large communications provider. The (simplified) t...
1 comment:
Friday, December 30, 2005

function WELL_KNOWN_FUNC does not exist

›
That came today in a newsgroup. A user was complaining that he was able to encrypt and decrypt some data with an early release of MySQL 5.0 ...
1 comment: