Archive for December 2009

The fading of Query Cache limitations

There is no question about the MySQL Query Cache greatness.  The MySQL Query Cache feature started his way with some limitations.  However, in time, there were a lot of improvements (fixing) for those limitations. One should test his MySQL version with the Query Cache limitations before using it. Here are some improved limitations I found […]

How to retain comments in MySQL statements

There is a lot of buzz lately around retaining comments in MySQL’s logs and MySQL Stored procedures (Routines). When analyzing a MySQL query, it’s nice to have a comment inside the query (or procedure) that can provide us with more info about the query. For example, When analyzing MySQL’s logs (like Slow Query Log or […]