…the amazing MySQL manual, especially the option and variable …Com_release_savepointblogpercona.commanual Com_rename_tableblogpercona.commanual Com_rename_userblogpercona.commanual Com_…Com_show_collationsblogpercona.commanual Com_show_column_typesblogpercona.commanual Com_show_contributorsblogpercona….

… all columns whenever they have changed or not: mysql> set foreign_key_checks=1; Query OK, 0 rows affected (0.00 sec) mysql… foreign key conditions (have column child table is referencing and have it of proper type and indexed): mysql> set foreign_key_checks… affected (0.00 sec) mysql> alter table parent rename parentx; Query OK, 0 rows affected (0.05 sec) mysql> drop table parentx; Query…

… new contents of the view with the old contents (using RENAME TABLE) which means that the view remains available for querying… customers nearly instantly. Note that every MV gets a special column `mview$pk` which is an auto_increment BIGINT surrogate key… useful, simply ignore this column. It is used to prevent wide innodb primary keys on the MV. mysql> select mview$pk as…