… target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup… same server. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with SQL rather than needing to…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…server warmup after the start. This feature is similar to the Dump/Restore of the Buffer Pool in Percona Server…to different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB….cc. Bug fixed #1162765. Other bug fixes: bug fixed #1158154, …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…server warmup after the start. This feature is similar to the Dump/Restore of the Buffer Pool in Percona Server…to different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB…“undefined”. Bug fixed #1171721. Other bugs fixed: bug fixed #1088307,…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… to ON, restoring from the LRU dump file is synchronous, i.e. InnoDB waits until it is complete before reporting successful startup to the server… work for them. mysqldump –innodb-optimize-keys has been fixed to take this into account. #812179 (Alexey Kopytov). Other Changes Improvements and fixes…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… to restore data from backup which can be far from being enough to restore the whole system to…to be very careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to… to be inconsistent withe each other, plus if server was seriously behind you’re risking to …
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… to ON, restoring from the LRU dump file is synchronous, i.e. InnoDB waits until it is complete before reporting successful startup to the server… work for them. mysqldump –innodb-optimize-keys has been fixed to take this into account. #812179 (Alexey Kopytov). Other Changes Improvements and fixes…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… were that the server was crashing under load when innodb_dict_size_limit was set to a smaller value. In order to simulate the… easily reproduced crash. I will admit that there may be other ways to go about hitting that particular bug, but we *were… ; ) parallel option breaks backups and restores For this bug, we needed to ensure that the server used –innodb_file_per_table and that we…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…restore here. Bug Fixes When adding a table to the cache, the server…to a server crash on IA32 systems. Bug Fixed: #803865 (Laurynas Biveinis). Using the innodb_lazy_drop_table option led to…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… Lorch III). Fixed issue where innodb_blocking_lru_restore did not take an optional bool argument similar to other bool options. Bug fixed #881001 (George Ormond Lorch III). Removed the unneeded lrusort.py script. The server now does…
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
…’ How this supposed to tell you Innodb (or for that sake any other Storage Engine) failed to initialize ? This error suppose to mean .frm file… and think it is indeed .frm corruption – trying to restore .frm from backup or other servers and being extremely frustrated as it does not…
