(Jan Kneschke) Some time ago I have shown that the proxy can do connection pooling and can keep server-side connections open to be reused by another client later. The keepalive tutorial shows how this can be implemented.

(Joe Brockmeier) So, now that the dust is starting to settle from the news that Sun is buying MySQL for a staggering $1 billion pricetag, let’s take a look at the larger picture– how is consolidation going to affect the open source ecosystem? MySQL was the first project in 2008 to be absorbed this

(Alexey Kovyrin) Really often in customers’ application we can see a huge tables with varchar/char fields, with small sets of possible values. These are “state”, “gender”, “status”, “weapon_type”, etc, etc. Frequently we suggest to change such fields to use ENUM column type, but is it really necessa

(Mark Callaghan) Chained and circular are popular methods to provide highly available database service for MySQL. They are popular because such a deployment is easy to manage and provides great uptime. Chained replication is also popular elsewhere. I want to use it, but I don’t and will explain why.

(George J. Trujillo Jr.) Stored procedures were introduced in the MySQL database server in version 5.0. It has been interesting to see the growth of stored procedures in the MySQL community because it is completely different with how stored procedures grew in the Oracle community.

(Shinguz) “A sparse file is a file where space has been allocated but not actually filled with data. These space is not written to the file system. Instead, brief information about these empty regions is stored, which takes up much less disk space. These regions are only written to disk at their act

(Jack Herrington) PHPMyAdmin rocks. Of that there can be no question. It’s easily one of the best PHP-based applications, because it trades the clunky command-line interface for MySQL administration for the web browser. But while it’s very powerful, it’s not very friendly to use or easy on the eyes.

(dbscience) Over the past four articles I’ve demonstrated cases where a denormalized data model is faster than a normalized one, but often not by that much, and a case where a normalized data model was a bit faster than a denormalized one. My general conclusion was with today’s optimizers one shoul

(Xaprb) I dashed off a hasty post about speeding up replication slaves, and gave no references or explanation. That’s what happens when I write quickly! This post explains what the heck I was talking about.

(Sean Hull) As you might imagine, migrating a database and its attendant applications is no small affair. Throw into the mix a switch of database platform, and you certainly have your hands full. In this two part article, we’ll be discussing all of the steps involved in this process, questions to