(Justin Swanhart) Often times I find myself having to handle a particular portion of a SQL statement via a script. I’ve written a lot of specialized regular expressions over time to handle these tasks, but the one that I’ve had to write the most is a basic ‘tokenizer’ which understands the quoting s

(Robert Hodges) 2009 has been a big year for Tungsten. In January we had (barely) working replication for MySQL. It had some neat features like global IDs and event filters, but to be frank you needed imagination to see the real value.

(Baron Schwartz) MySQL has a couple of sanity-check features to help keep you from doing dumb things.

(Giuseppe Maxia) The release of MySQL 5.5 has brought several enhancements. While most of the coverage went, understandably, to the semi-synchronous replication, the enhancements of partitioning were neglected, and sometimes there was some degree of misunderstanding on their true meaning. With this

(Greg Sabino Mullane) Users toggling between MySQL and Postgres are often confused by the equivalent commands to accomplish basic tasks. Here’s a chart listing some of the differences between the command line client for MySQL (simply called mysql), and the command line client for Postgres (called ps

(Rob Gravelle) Did you know that MySQL has supported subqueries since version 4.1? In fact, it even boasts a few MySQL-specific features! Whether you’re well acquainted with subqueries or just a novice in this area, you’re bound to benefit from today’s article, which will cover how to use subqueries

(Mats Kindahl) Keeping a MySQL installation up and running can be quite tricky at times, especially when having many servers to manage and monitor. In the replication tutorials at the annual MySQL Users’ Conference, we demonstrate how to set up replication appropriately and also how to handle variou

(Peter Zaitsev) When we’re looking at mk-query-digest report we typically look at the Queries causing the most impact (sum of the query execution times) as well as queries having some longest samples. Why are we looking at these?

(Roland Bouman) The latest MySQL 5.5 milestone release offers support for an ANSI/ISO standard feature called the SIGNAL syntax. You can use this syntax inside stored routines (including triggers) to raise an error condition which can be used to invoke specific error handling, or otherwise abort the

(Greg Sabino Mullane) One of the more recent additions to check_postgres, the all-singing, all-dancing Postgres monitoring tool, is the “same_schema” action. This was necessitated by clients who wanted to make sure that their schemas were identical across different servers. The two use cases I’ve se