…from the Percona Software Repositories). Based on MySQL 5.1.66, including all the …it once it is replayed during binlog crash recovery. Bug fixed #1012715 (Laurynas Biveinis). Although …1039536 (Alexey Kopytov). In cases where indexes with AUTO_INCREMENT columns where correctly detected, mysqldump …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… #1017192 (Sergei Glushchenko). The server could crash when executing an INSERT or …line option innodb_changed_pages_limit. MySQL option handling would then shadow …needs to have more than one auto-increment table and the slave … wasn’t compatible with innodb_force_recovery=6. When starting the server …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… resize_inode dir_index filetype needs_recovery extent 64bit flex_bg spars e…setup which would cause server to crash instead of continuing in half working…for partition you store MySQL data on, as chances are MySQL server is only… much better to disable both these auto check functions for your data …
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…_xtrabackup. (Yasufumi Kinoshita) Old system variable innodb_auto_lru_dump was renamed to innodb_buffer…_relay_log_info was renamed to innodb_recovery_update_relay_log. (Yasufumi Kinoshita) Old system….1.7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL bugs have …
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… pages, saving IO dramatically. No recovery worries – checking/repairing large MyISAM tables in case of MySQL/System crash is painful and great to be avoided. Long primary key – why did not I use auto_increment id…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…_recovery=1 you can do the following: mysql> CREATE TABLE `test2` ( -> `c` char(255) DEFAULT NULL, -> `id` int(10) unsigned NOT NULL AUTO… may want to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So we…. I should also mention at Percona we offer assistance in MySQL Recovery, including recovery from Innodb corruptions and deleted data.
