(Antoni Wolski) This is, of course, about Pessimistic and Optimistic–the two concurrency control interfaces used in database products. The idea is simple–or not, depending whether you confuse it with something else or not. Very often it is being confused with another pair of alternative choices in

(Mark Callaghan) Synchronous replication for MySQL is here, well almost here. Solid has announced a product that will be available in 2007 to provide this. I anxiously await the details. And now, source code is available for an implementation of semi-synchronous replication that works with MySQL 4.0

(Sheeri Kritzer) This article shows the easiest way to audit commands to a MySQL database, assuming all content happens from an application. Now, this will use a lot of storage, and doubles the query load for each query, but it’s useful for when you know you want to capture the information of someon

(Yannick Gratton) I got tired of going all over the place to get information about mysqld variables, so I decided to make a summary of most of them (for version 5.0.27 linux). (Due to lack of horizontal space, I had to make two tables — the second one containing a short description of the variable.)

(Ronald) I’ve been playing more with the SHOW PROFILE command available as part of MySQL Community 5.0.37. Thanks to the author Jeremy Cole. This command can provide some interesting insight into the workings of MySQL. It does however like most new releases of software enable users to make suggestio

(Tim Schwallie) Microsoft in ASP.NET 2.0 has opened up the Session State mechanism in ASP.NET so that we can use their provider concept and create our own providers to store ASP.Net Session State data.

(Tim Procter) There are various tools available for gathering and monitoring mysql performance data, but it’s not always clear what they mean, what is important, and what can be tuned. I’m not going to try to post a comprehensive mysql tuning manual here. This post is about taking a snapshot profile

(Peter Zaitsev) So you’re running dedicated MySQL Linux box with plenty of memory, so the good question arises if you should have swap file enabled or disable it ? I’ve seen production successfully running on boxes both with and without swap file so it is not the question of you must do it this or t

(Nicholas Goodman) I’m visiting a Pentaho customer right now whose current “transaction” volume is 200 million rows per day. Relatively speaking, this puts their planned warehouse in the top quintile of size. They will face significant issues with load times, data storage, processing reliability,

(Xaprb) A frequently asked question about MySQL replication is “how do I know whether my slave is identical to the master?” Until recently there hasn’t been a good way to know, but now you can compare all the data in your master to the data in the slaves and get a reliable yes-or-no answer. And you