(Sergey Petrunia) Starting from 5.1.18, EXPLAIN output may show “Using join cache”, like in this example:

(Xaprb) A few people have asked me how fast MySQL Table Checksum is. As with so many other things, it depends. This article shows how long it takes to checksum real data on a production server I help manage, which might give you a rough idea of how long it’ll take on your servers.

(Peter Zaitsev) I promised to write little articles about all storage engines which sessions I attended during MySQL Users Conference but I did not get too far yet, too busy. So today it is time for PBXT.

(Xaprb) I’ve written before about how to make MySQL replication reliable. One thing I think you need to do to make statement-based replication reliable is eliminate temporary tables. I found an elegant way to replace temporary tables with real tables in the systems I maintain. This article explains

(Frank Mashraqi) Last year at the MySQL camp, I heard about Paul Tuckfield’s script that pre-fetches relay logs to speed up replication. Since then I got really interested in implementing it but never got the time. This year at MySQL conference Paul’s script got a lot of attention again. Since it ha

(Jay Janssen) I’m really excited about MySQL Cluster. It has a lot of potential to be a good competitor to Oracle RAQ, and not just in a copy-cat kind of way.

(Kevin Burton) This is a hack I’ve heard about a couple times now: Paul wrote a script that reads from the logfile the queries that are going to be executed moments later. He parses the queries and constructs new select queries that populate the cache with the data that speeds up the upcoming wri

(Peter Zaitsev) I had the interesting customer case today which made me to do a bit research on the problem.

(Jay Janssen) MySQL replication is cool. Almost everyone, when asked what they like best about MySQL, will mention replication. There can be no doubt that many web companies, Yahoo included, owes much to MySQL replication. How else can you scale the reading capacity of your database so easily?

(Frank Mashraqi) With this post, I am starting another series of blog posts that will help you become familiar of DTrace. You can then apply that knowledge to find all the hidden performance goodies of MySQL on Solaris 10. Sounds good?