…captured. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty …SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<‘EOF…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password … missing. Bug fixed #1179974. Server would crash if an INNODB_CHANGED_PAGES query is issued that … is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the …
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…InnoDB. Bug fixed #1170103. Fixed the RPM packaging regression that was introduced with the fix for bug #710799. This regression caused mysql…, Crash-…MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] …integers now. Bug fixed #714925. Server would crash if an INNODB_CHANGED_PAGES query is issued that has…files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock…ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the … ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port … in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo…Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… an option: Table was dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL There is yet another source of information about the table structure – InnoDB dictionary. Let’s review tables from the dictionary…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb…). Percona Server for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed by… the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…crash, it has to get to disk. This has no effect on standard MySQL replication from this instance, since MySQL…maintained in separate tables and there also exists a users_groups table to define the …take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options, all …some of the programs that use it to crash. Fixed by building packages with OpenSSL support … was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981. Other…
