(Vincent Danen) MySQL is still the most popular open source SQL database available. And while many MySQL administrators (myself included) are strict adherents of using the mysql command-line client, those who prefer GUI tools have several choices available.

(Shlomi Noach) In a period of two weeks, I had two cases with the exact same symptoms.

Whether you’re working with MySQL, MySQL Cluster, or any other RDBMS, every database with a requirement for persistent data should have a backup. As a Production DBA you’re the insurance policy to safeguard the data. Bad things do happen. Backups are your safety net to ensure you always have a way t

(mahmud ahsan) MySQL stored procedures are programs that are stored and can be executed on the MySQL server. You can call stored procedure from any application over a distributed network. Stored procedures provide a means of interacting in a prescribed way with the database without placing any addit

(Mats Kindahl) It is with interest that I read Kristian’s three blogs on the binary log group commit. In the article, he mentions InnoDB’s prepare_commit_mutex as the main hindrance to accomplish group commits—which it indeed is—and proposes to remove it with the motivation that FLUSH TABLES WITH RE

(Giuseppe Maxia) While I was presenting my partitioning tutorial at the latest MySQL Conference, I announced a new feature that was, as far as I knew, still in the planning stage. Mattias Jonsson, one of the partitions developers, was in attendance, and corrected me, explaining that the feature was

(Greg Sabino Mullane) Getting visibility into what your PostgreSQL function is doing can be a difficult task. While you can sprinkle notices inside your code, for example with the RAISE feature of plpgsql, that only shows the notices to the session that is currently running the function. Let’s look

(Giuseppe Maxia) Yesterday I was testing a branch of MySQL 5.5 to help a colleague, and I was set aback at discovering that, with the default build options, the server did not include the Archive engine.

(David Wheeler) I’ve been writing a fair bit of PL/Perl for a client, and one of the things I’ve been doing is eliminating a ton of duplicate code by creating utility functions in the %_SHARED hash. This is great, as long as the code that creates those functions gets executed at the beginning of eve

(Mark Robson) How do we stream data from MySQL? Traditionally, developers have thought that they can simply use their API’s cursor-equivalent object (e.g. resultset) and move through the results.