… captured. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace….sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…-bit unsigned integers now. Bug fixed #714925. Server would crash if an INNODB_CHANGED_PAGES query is issued that has an empty… any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O… an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… to a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O… LSN range was missing. Bug fixed #1179974. Server would crash if an INNODB_CHANGED_PAGES query is issued that has an empty… changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB… with the binary log disabled, Crash-Resistant Replication could overwrite the …, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and… cosmic ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
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…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… key reference could cause a slave crash. Fixed by using primary key of the child table when appending exclusive key for cascading… fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements… adding a new method to cancel a thread waiting for InnoDB concurrency. Bug fixed #1155183 (Seppo Jaakola). Handling of the network…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… #1168540. Percona XtraBackup would crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been… could cause some of the programs that use it to crash. Fixed by building packages with OpenSSL support rather than the…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been… could cause some of the programs that use it to crash. Fixed by building packages with OpenSSL support rather than the…
