Wednesday, January 25, 2006

A little look into the (near) future

In August, I've filed a Feature Request and suggested to allow logging into database tables additionally to writing log files to the file system. The development is in progress and it's told that the feature will probably be available in one of the earlier 5.1 releases.

We also know, that in MySQL 5.1.6 the Event Scheduling Feature will be available - read more about it here:

The combination of these two new features will give great new possibilities. The log data will be available more conveniently and it will also be very easy to filter those records that are of interest (with simple SQL statements). The Event Scheduling Feature can be run at regular intervals to filter out particular records, or to accumulate data - all possible kinds of things. This way it will be much easier and more comfortable for DBAs to find out, what's exactly going on on the MySQL server.

1 comment:

Sheeri said...

Hi Markus! I did see this article -- it's different from my request in that we want to log *only* DDL statements. Logging DML on our site that has so many updates would be a waste of I/O -- we'd have to run a cleanup script to delete anything that's DML. We want to keep the DDL around for a long time, the DML for a short time. Right now we can have scripts in place to do that, but they are tedious.