… some compiler warnings. (Stewart Smith) Ported XtraBackup to MySQL 5.1.55, MySQL 5.5.9, Percona Server 5.1.55-12… instead of crashing. (Alexey Kopytov) Bug #688211 – Using the –password option with innobackupex to specify MySQL passwords containing special shell characters (such…. Bug #688417 – It’s now possible to do incremental backups for compressed InnoDB tables. Bug #701767 – The script innobackupex-1.5.1 was renamed…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…’re running MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and some… old table and convert new table back to Innodb after restarting without innodb_force_recovery option. You can also rename the old table in…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…_safe which will restart MySQL Server in most cases. It is great, unless you have run into some bug which causes it…, not to mention such potentially multiple operation DDL statements as RENAME TABLE – these are most vulnerable. master.info corruption – If slave happens… table or any other statement – it is table open which is important. There are other problems which you may experience related to MySQL…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…Old system variable innodb_pass_corrupt_table was renamed to innodb_corrupt_table_action. (Yasufumi Kinoshita) Bug Fixes Bug #724674 – Ported an updated version ….7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL bugs have been fixed in Percona Server. (Yasufumi …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… table | 0.002255 | | After create | 0.000050 | | copy to tmp table | 61.816063 | | rename result table…table rebuilds without affecting the table size. mysql> SET expand_fast_index_creation=ON; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE…Peter’s post MySQL bug #57583 MySQL bug #49120 …
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…More pluggability, including pluggable authentication In addition to building on MySQL 5.5, here are the changes we’ve made …INFORMATION_SCHEMA table XTRADB_ENHANCEMENTS was removed. (Yasufumi Kinoshita) Several fields in the INFORMATION_SCHEMA table INNODB_INDEX_STATS were renamed. Bug fixed: #…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…. You should not think about this however as about bugs, as many MySQL features it is designed for particular load cases when… databases first an then rename them back to MySQL database directory. This way accesses to non-checked tables fail with table does not exist error rather than wait forever. Hidden corruptions. If could be bad memory OS or MySQL bugs…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
…it was forgotten) New patch innodb_relax_table_creation Added extended statistics to slow … Fixed bugs: Bug#488315: rename columns and add unique index cause serious inconsistent with mysqld Bug #495342… to compile on OpenSolaris†Bug #47621: change the fix of http://bugs.mysql.com/47621 more …
Comment: Why Swapping is bad for MySQL Performance ?
January 19, 2010 By 11 Comments
… from MySQL itself and is out of your (direct) control (see http://www.masterzen.fr/2009/10/15/mysql-innodb-and-table-renaming-dont-play-well/ and http://bugs.mysql.com/bug.php?id=47991). It’s not…
