… captured. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace…/lib/mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… 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…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force … missing. Bug fixed #1179974. Server would crash if an INNODB_CHANGED_PAGES query …for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table… or replication may be broken. Scenario #3: The master has crashed before sending all writes If the binary logs of the…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption]… for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS…integers now. Bug fixed #714925. Server would crash if an INNODB_CHANGED_PAGES query …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…have to start the snapshot while holding a “flush tables with read lock” and the flush operation will …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 on…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
….user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used when… it will still replicate in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo Jaakola). In case… Jaakola). If MySQL replication threads were started before running wsrep recovery, this would lead to memory corruption and server crash. Bug fixed…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… 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…. `ID` is a table identifier. We will need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed…). Percona Server for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed by… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.68-14.6[/caption] Percona is glad… could cause some of the programs that use it to crash. Fixed by building packages with OpenSSL support rather than the…. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981. Other bugs fixes…
