… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… LSN range was missing. Bug fixed #1179974. Server would crash if an INNODB_CHANGED_PAGES query is issued that has an empty… if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage… InnoDB. Bug fixed #1170103. Fixed the RPM packaging regression that was introduced with the fix for bug #710799. This regression caused mysql… log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… captured. The –apply-logs phase simply utilizes the built in crash recovery and applies the redo-logs to the dirty tablespace… Load the schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… objects are now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write performance for high levels…-bit unsigned integers now. Bug fixed #714925. Server would crash if an INNODB_CHANGED_PAGES query is issued that has an empty…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… cosmic ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
… -l /var/lib/mysql/ib_logfile* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep… mysql mysql 536870912 May 21 22:24 /var/lib/mysql/ib_logfile1 Of course it is worth reiterating the point made by AFTAB, crash…
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… fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… 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…
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 …. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release… XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps… cause XtraBackup to crash. Bug fixed #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm…
