Hacking MySQL table logs

May 08 2007

Shortly before MySQL Users Conference I announced that I would be cover new ground in table logs management. I am keeping that promise, and in addition I am also showing some related hacks. The announced facts from last year usability... read more

Hacking MySQL table logs

May 08 2007

Shortly before MySQL Users Conference I announced that I would be cover new ground in table logs management. I am keeping that promise, and in addition I am also showing some related hacks. The announced facts from last year usability report were that you can't change log tables at will, as you… read more

Handling multiple data sets in MySQL stored procedures from Perl

April 12 2007

MySQL stored procedures can use SELECT statements in their body, returning a data set to the caller. The manual also explains that multiple data sets can be returned from such a stored procedure. For example, assume you have this stored procedure: CREATE PROCEDURE p1(x INT, y INT) DETERMINISTIC BEGIN SELECT x ;… read more

MySQL rewards its community

March 12 2007

After a long period of preparation, my pet project is out! The Quality Contribution Program is here! MySQL wants to reward its most active users who are contributing to the improvement of its products. This is not a lottery, where you submit some contributions, and if you are chosen you get… read more

Federated, Blackhole, and Contributors at the MySQL Conference and Expo 2007

March 12 2007

I will be involved in two sessions at the MySQL Users Conference and Expo 2007. The Blackhole and Federated Storage Engines: The Coolest Kids on the Block, a four-hands presentation with Kai Voigt Lightning Rounds with Top MySQL Community Contributors where I will be the moderator among a group of… read more

Seeking community contribution for MySQL QA

October 19 2006

MySQL has recently started a campaign of open contribution, inviting the community to participate to the MySQL project in many ways. The next target, also considering the higer stakes coming from the MySQL Enterprise challenge, will be Quality Assurance. Quality Assurance Now what is Quality Assurance (QA)? If you think that it’s just… read more

Measuring resources for a MySQL server on Linux

July 06 2006

Sometimes my customers (especially the ones who are used to different database servers,) ask me about the CPU and memory consumption of a MySQL server process. Initially I thought that this kind of requests were rather odd, mostly because the whole box was dedicated to the database, thus measuring the global… read more

Introducing the MySQL Sandbox

May 24 2006

Installing a side instance of MySQL for testing purpose is a task that many administrators can perform without breaking a sweat. If you need to do that only once in a while, you need just to read the manual carefully, or to have some experience in this matter, and the… read more

Dumping MySQL information schema

April 08 2006

One of the recent MySQL enhancements was the INFORMATION_SCHEMA data dictionary, which gives a more coherent view on the DBMS meta-data. Useful as it is, the information schema is becoming widely used, and many DBAs are learning how to use it as an administration and debugging tool. So useful, in fact,… read more