(John Dzilvelis) What started out as a key buffer efficiency study turned to a fruitless search for ways to overcome a somewhat high ( ~20%) amount of unusable key buffer space. This behavior seems to be platform and version independent as I observed this with versions 5.0.45, 5.0.52, and 5.1.22 on

(Kevin Burton) I’ve now had about 24 hours to play with the Mtron SSDs and had some time to benchmark them.

(Peter Zaitsev) As MySQL Manual Says Query Cache works with transactions with Innodb tables but it does not tell you how and with which restrictions.

(CrazyToon) Before we go into how to set up master/slave replication in MySQL, let us talk about some of the reasons I have set up master/slave replication using MySQL.

(Peter Zaitsev) As you might know even if you’re only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is likely for relay logs to run out of sync (they are not synced to the disk) plus position on the master which slave remembers b

(Sheeri Cabral) A friend asked for this, so I thought it’d be helpful:

(George J. Trujillo Jr.) A lot of the popularity of MySQL is its ease of installation and how easy it is to use out of the box. Anyone can install MySQL pretty easily. That is the danger of MySQL. Because MySQL is so easy to install, people can forget or not realize that MySQL is a full blown databa

(Frank) My thoughts have changed on this topic over time. Primarily, because I now work on a large scale infrastructure where I can see how things would have been if BLOBs were stored in database. Most of the following discussion keeps the size and scale of my work load in mind and is targeted towar

(Curt Monash) Based on a variety of conversations – including some of the flames about my recent confession that mid-range DBMS aren’t suitable for everything — it seems as if a quick primer may be in order on the subject of datatype support. So here goes.

(BSchwarz ) Here is a quick tip showing you how to add mySQL and PHP to your Windows Server path. Many people ask how to do this and while it is included in the Installing mySQL and Installing PHP tutorials I thought I would make it easier for everyone to get the information.