… statement. mysql> create table t1 (a int not null auto_increment, primary key(a)); Query OK, 0 rows affected (0.11 sec) mysql> insert… turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL… you are done, you may use mode=cleanup to kill off any servers: ./kewpie.py –mode=cleanup Setting –no-secure-file…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
…CREATE TABLE example ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, fname TEXT NOT NULL, fcomment TEXT, ftitle…; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â…limit, InnoDB chooses variable length columns for off-page storage. In these cases, the first…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… well when all you want is to remove auto_increment or change ENUM values. When it comes to…our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master… OK, the procedure: 1. on monitor: set db2 off-line $ mmm_control @C1 set_offline db2 …
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… my.cnf. This. At my last job we ran the MySQL off of the ‘small’ cnf (other than max connections, and slow… int, but I have had to clean up when an auto increment column runs out of room to expand. I am not…
