《MySQL 5.5 Guide to InnoDB Status》.pdfVIP

MySQL 5.5 Guide to InnoDB Status Bill Karwin, Percona Inc. Me • Software developer • C, Java, Perl, PHP, Ruby • SQL maven • MySQL Consultant at Percona • Author of SQL Antipatterns: Avoiding the Pitfalls of Database Programming Bill Karwin MyISAM or InnoDB? • MyISAM can store more compactly • MyISAM supports FULLTEXT indexes • MyISAM uses primary keys and secondary keys in the same way BUT... • MyISAM does not support transactions • MyISAM allows updates to write non-atomically • MyISAM is susceptible to corruption on crashes • MyISAM relies on filesystem cache InnoDB Plugin 1.0 • Enable in /etc/f: [mysqld] ignore-builtin-innodb plugin-load=innodb=ha_innodb_plugin.so • Verify InnoDB plugin is enabled: mysql SHOW PLUGINS; ++++++ | Name | Status | Type | Library | License | ++++++ | InnoDB | ACTIVE | STORAGE ENGINE | ha_innodb_plugin.so | GPL | ++++++ InnoDB Plugin 1.1 • Not necessary to enable InnoDB Plugin 1.1 • Default storage engine in MySQL 5.5 How to Show InnoDB Status mysql SHOW ENGINE INNODB STATUS \G required keyword in 5.5 output without long table borders ===================================== INNODB MONITOR OUTPUT ===================================== ===================================== 111001 19:29:44 INNODB MONITOR OUTPUT =