…defined types are: FIL_PAGE_INDEX, FIL_PAGE_UNDO_LOG, FIL_PAGE_INODE, FIL_PAGE_IBUF_…taken from some MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql>CREATE TABLE actor ( actor_…in InnoDB dictionary for table test/t2 In this case you need to drop table `test`.`t2` and create…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
… is fixed value. This patch expands the maximum number of undo slots to 4072 and allows better utilizing modern hardware. (Thank… compiled in into MySQL-5.1.30 RPM as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30 installation XtraDB is compatible with existing InnoDB tables (Warning: unless you…
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… would be just the table it should have been easy – dropping the table with corrupted page …undo buffer. True this would leave some tables corrupted but at least you could get by by dumping in reimporting couple of tables…sorts of different things: Versions later than MySQL 5.0.33 are not frequently …
Post: Small things are better
October 8, 2006 By 15 Comments
… ALTER TABLE to rebuild the table fixes it. Sometimes table needs to be dropped and recovered…if corruption is happens to be in undo tablespace or log files. So …tables allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet another reason to keep tables…
