Mysql

From KeegansWiki
Revision as of 05:53, 9 June 2011 by Keegan (talk | contribs) (Created page with '=InnoDB= ==Won't start== * Delete ib_logfile* logs, restart =Info= ==Create a simple InnoDB table== * ''CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;'' ==…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

InnoDB

Won't start

  • Delete ib_logfile* logs, restart

Info

Create a simple InnoDB table

  • CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;

InnoDB Status

  • show engine innodb status\G;