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 [...]
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 [...]
A while ago, I were searching for a way to produce random rows from a table in MySQL. I found several solutions but none of them satisfied me. Of course, I could use a combined logic of MySQL and a programming language. For example by producing random numbers in PHP and using them in the MySQL query in a IN clouse. However, I [...]
