…_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: Announcing Percona Server 5.5.27-29.0
October 11, 2012 By Leave a Comment
…from command line. Fixed by renaming innodb_sys_stats_root_page to innodb_persistent_stats_root_page. Bug fixed #1013644 (Laurynas …non-default maximum number of indexes per table. Upstream MySQL bugs: #54127, #61178, #61179 and #61180. Bug fixed #1042517 (Sergei Glushchenko). Release notes for…
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: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… values for a compressed table. This regression was introduced in Percona Server 5.1.59-13.0. Bug fixed #1100159 (Laurynas Biveinis…_limit. MySQL option handling would then shadow the former with the latter, resulting in start up errors. Fixed by renaming the innodb… Server for MySQL 5.1.67-14.4: bug fixed #1098436 (Laurynas Biveinis), bug fixed #1096904 (Laurynas Biveinis), bug fixed #1096899 (Laurynas Biveinis), bug fixed…
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
…, THREAD_STATISTICS and USER_STATISTICS tables in the INFORMATION_SCHEMA database. Bugs Fixed: A Server acting…. This bug was introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug fixed #… file first, and then rename it to the actual dump file. Bug fixed #686392 (George Ormond …
Post: Percona Toolkit versions 2.0.5 and 2.1.2 released
June 12, 2012 By 1 Comment
… several bugs in pt-table-sync that prevented it from working properly, and disabled the –lock-and-rename feature when using it with MySQL versions that don’t support it reliably. We enhanced pt-table-checksum and pt-online-schema-change to add even more safety checks, and to detect and deal with some MySQL…
Post: Using MyISAM in production
June 17, 2006 By 36 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…
