(Keith Larson) I was recently talking with a few people and the concept of summary tables came up as solutions for them. The issue is, they never thought of it. Hopefully this post will help them as well as others.

(Kristian Köhntopp) In Maximum MySQL Database Size? Nick Duncan wants to find out what the maximum size of his MySQL database can possibly be. He answers that with a list of maximum file sizes per file system type. That is not a useful answer.

(Rob Gravelle) MySQL’s enormous popularity is a double-edged sword for the people who depend on it. On one hand, it’s not liable to become outdated any time soon. On the other, the world’s favorite open source DBMS has made itself a target of hackers who desire to steal its precious data, or just d

(Baron Schwartz) After the recent update to pt-table-checksum, I’ve seen a few FAQs about it.

(Shlomi Noach) Some administrative tasks can be simplified by using common_schema/QueryScript. I’m collecting a bunch of these for documentation. Here’s one for example:

(Mark Grennan) Un-maned Failover Operations

(Shinguz) In my set-ups I have different MySQL versions (MySQL 5.0, 5.1, 5.5 and 5.6, Percona Server 13.1 and 24.0, MariaDB 5.2.10, 5.3.3, Galera 1.0, 1.1 and 2.0) running in parallel at the same time.

(OpenSorceDBA) At yesterdays MySQL Tech Tour in Dallas, a gentleman asked how to not only partition data but also store the indexes on other disks as a way of reducing I/O contention on drives.That struck a chord with me and I was soon looking up the information in the MySQL manual.

(Shlomi Noach) Introducing QueryScript: a programming language aimed for SQL scripting, seamlessly combining scripting power such as flow control & variables with standard SQL statements or RDBMS-specific commands.

(Jonathan Levin) In relation to this MPB post, there is a command to output data into a file and then to load it back into MySQL to resolve locks. (An example of a really big reporting query that could be quite heavy, can be found here.)