(Jaime Crespo) default_tmp_storage_engine variable was introduced in 5.6.3, allowing the configuration of the default engine for temporary tables.

(Brock Wilson) MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues.

(Baron Schwartz) There’s no such thing as a schemaless database. I know, lots of people want a schemaless database, and lots of companies are promoting their products as schemaless DBMSs. And schemaless DBMSs exist.

(Petri Virsunen) Analyzing transactional data is becoming increasingly common, especially as the data sizes and complexity increase and transactional stores are no longer to keep pace with the ever-increasing storage. Although there are many techniques available for loading data, getting effective d

(Kedar Vaijanapurkar) In this post I will share a recovery scenario of a MySQL database restore from the binary logs.

(Baron Schwartz) If you’ve ever looked at the COM_XYZ status counters in MySQL’s SHOW STATUS output, you’ve probably seen Com_admin_commands. It’s not clear what this means, but it can be a major contributor to overall COM_ counters, and it’s actually quite important for server and application perfo

(Ted Wennmark) I visited a customer some weeks back and saw some regression problem during an upgrade to MySQL 5.6. Problem was during initial setup of database, the CREATE TABLE statements was running much slower on MySQL 5.6 compared to MySQL 5.5.

(Rob Gravelle) DBAs – and pretty much everyone else – tend to focus so much on data input and storage that they forget about the reason that they’re hoarding all of that information in the first place, which is to do something useful with that data.

(Fernando Laudares) This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster (PXC). The main one being the fact that transactions touching MyISAM tables (and FLUSH PRIVILEGES!) issued on a

(Tony Darnell) MySQL’s default storage engine as of version 5.5 is InnoDB. InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory.