This is an old post I put on the old mysqlhow2.com that ended up on modphp.org. Both sites are run by people I know so it's coo. Anyway, I thought it read more »
Tungsten Replicator version 1.0.3 is now released and available as a download from Source Forge. Tungsten Replicator provides advanced, platform-ind read more »
I was debugging the performance of a DELETE statement that contained a subquery in the FROM clause. As there is no EXPLAIN for DELETE, I converted it read more »
This is a reposting of http://sarahdba.blogspot.com/2009/09/mysqls-query-cache.htmlMySQL's query cache is somewhat unique and can be very read more »
I'm pleased to announce the release of Spider storage engine version 2.2(beta).Spider is a Storage Engine for database sharding.http://spiderformysql read more »
I am happy to announce that mylvmbackup version 0.13 has now been released. This release includes a fix for a nasty bug in on of the recently added read more »
MySQL replication is a great feature: it's easy to setup and relatively easy to manage, it can provide scalabilty and availability, a master can serv read more »
Go to ProfilesClick on AdvancedHighlight Active profileClick on Menu and select EditSMS Text/Phone/MMS etc.Select Tone read more »
This is a simple technique, to write a report that generates SQL syntax, that you can then turn around and execute. I've heard this called "SQL from read more »
mysqlnd patched for compressed protocol passes almost all tests, but all of the most relevant and those who test with big result sets. I have a few f read more »
Testing Secure ReplicationFor the first test I used encrypted (SSL) replication and inserted 200,000 records using three 10 minute discon read more »
There is a serious bug with the sphinx storage engine, introduced in 0.9.9-RC2 (and which has not been fixed in latest revisions, as yet – last read more »
Andrey mentioned it long ago: MySQL Connector/C++ 1.1.0 makes use of some Boost components. The change impacts those who compile the MySQL driver for read more »
Matt Asay has written an interesting post speculating that Oracle might use the delay caused by the European Commission investigation into its acquis read more »
The Facebook patch for MySQL has more performance counters to understand the sources of disk IO from InnoDB. The data below is from a slave that is i read more »


Any coments? Contact us.