Concurrent DML but Table Copy Still Required Some other ALTER TABLE operations allow concurrent DML, and are faster than MySQL 5.5 and prior: the table-copying operation is optimized, even though a table copy is still required: • Adding, dropping, or reordering columns. • Adding or dropping a pr...
MySQL Community Support at the MySQL Forums The forums at http://forums.mysql.com are an important community resource. Many forums are available, grouped into these general categories: • Migration • MySQL Usage • MySQL Connectors • Programm...
Perform any necessary postinstallation setup. After installing MySQL, read Section 2.10, “Postinstallation Setup and Testing”. This section contains important information about making sure the MySQL server is working properly. It also describes how to secure the initial MySQL user accounts, which...
The Noinstall Archive: This package has a file name similar to mysql-5.6.14-win32.zip or mysql-5.6.14-winx64.zip, and contains all the files found in the Complete install package, with the excep...
Using AUTO_INCREMENT The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows: CREATE TABLE animals ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); INSERT INTO animals (name) VALU...
Tuning Performance of the InnoDB memcached Plugin Because using InnoDB in combination with memcached involves writing all data to disk, wh...
Unsupported or Missing Features in MySQL Cluster A number of features supported by other storage engines are not supported for NDB tables. Trying to use any of these features in MySQL Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the feature...
Updates involving nontransactional storage engines. When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot made in the same statement or transaction as updates to tables using transactional storage engines...
Upgrading a Replication Setup When you upgrade servers that participate in a replication setup, the procedure for upgrading depends on the current server versions and the version to which you are upgrading. This section applies to upgrading repl...
Usage of Row-Based Logging and Replication Major changes in the replication environment and in the behavior of applications can result from using row-based logging (RBL) or row-based replication (RBR) rather than statement-based logging or r...
