(Ernie Souhrada) Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that didn’t understand this limitation would often have tables with lots of single-column indexes on columns which commonly appeared in their WHERE clauses, and they’d wonde

(Kevin Knapp) From http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html: “You can also set the expire_logs_days system variable to expire binary log files automatically after a given number of days… you should set the variable no lower than the maximum number of days your slaves might la

(Shlomi Noach) If you are familiar with both openark kit and common_schema, you’ll notice I’ve incorporated some functionality already working in openark kit into common_schema, essentially rewriting what used to be a Python script into SQL/QueryScript.

(Andrew Dunstan) This is not a great breakthrough, but I had to wrestle slightly with it yesterday in the context of writing an extension with a variadic Postgres function in C.

(Rob Gravelle) The SQL language that was first developed by IBM in the early seventies was adopted as a standard by the American National Standards Institute (ANSI) in 1986 as SQL-86 and the International Organization for Standardization (ISO) in 1987. MySQL Server follows the ANSI SQL standard by

(Martin Farach-Colton) We get a lot of questions about how Fractal Tree indexes work. It’s a write-optimized index with fast queries, but which write-optimized indexing structure is it?

(Tony Darnell) This post is the second in a series that I will be doing on MySQL Workbench Utilities – Administer MySQL with Python Scripts. You may want to read the first half of this post to understand how MySQL Workbench Utilities work and how you access the scripts.

(Shlomi Noach) The issue of terminating long-time idle open InnoDB transaction has been discussed recently by many. I wish to add my share, by proposing a quick and clean solution via common_schema.

(Shinguz) MySQL hosting providers can easily loose the overview over their customers and which user or schema is still in use and which not.

(Ivan Cachicatari) I was tired to get manually disk space used for all MySQL databases, I just created a stored procedure to get an overview of the database sizes in our MySQL server.