This post was initially going to be two sets of polls: “What is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder those questions and come up with your own answers… and see if you’re right or can prove me wrong! [...]
Understanding the maximum number of columns in a MySQL table
Filed Under: MySQL Tagged With: columns, CREATE TABLE, ddl, FRM, limits, MySQL, MySQL table, Perl, UNIREG
Implications of Metadata Locking Changes in MySQL 5.5
While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3. It appears that the implications of Metadata Locking have not [...]
Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: alter table, ddl, metadata locking, query cache, table cache, transaction, Transaction isolation

