(Ronald Bradford) The Maatkit tools provide a suite of additional MySQL commands. There is one command I use constantly and that is mk-query-digest.

(Kristian Nielsen) Here is an analogy that describes well what group commit does. We have a bus driving back and forth transporting people from A to B (corresponding to fsync() “transporting” commits to durable storage on disk). The group commit optimisation is to have the bus pick up everyone that

(MySQL Boy) You might be fortunate enough to allow yourself some downtime, it is dependent on your application and business model. During this window it’s possible for you to stop your MySQL daemon or lock your tables to give yourself a consistent backup of your data.

(Quassnoi) In one of the previous articles I discussed performance of the three methods to implement an anti-join in MySQL.

(Baron Schwartz) I wrote recently about early detection for MySQL performance problems. If your server is having micro-fluctuations in performance, it’s important to know, because very soon they will turn much worse. What can you do about this?

(Daniel Nichter) I’ve been thinking a lot about invalid and zero temporal values and how to detect them with MySQL date and time functions because mk-table-checksum has to handle “everything” correctly and efficiently.

(Roland Bouman) From a functional perspective, the core SQL support in all major and minor RDBMS-es is reasonably similar. In this light, it’s sometimes quite disturbing to find how some very basic things work so differently across different products. Consider this simple statement:

(Chris Schneider) This article contains common different methods of functional partitioning and common considerations for database setup and capacity. Company DBAs, database developers, engineers and architects should consider the pros and cons of any method of sharding or partitioning since comprom

(Justin Swanhart) Over the weekend I spent a lot of time improving my new Shard-Query tool (code.google.com/p/shard-query) and the improvements can equate to big performance gains on partitioned data sets versus executing the query directly on MySQL.

(Peter Zaitsev) One schema optimization we often do is extending index when there are queries which can use more key part. Typically this is safe operation, unless index length increases dramatically queries which can use index can also use prefix of the new index are they ? It turns there are speci