…:24 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May 21 22:24 /var/lib/mysql/ib_logfile1 Of course it is worth reiterating the point made by AFTAB, crash recovery is far cheaper in modern versions of…: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the size of your redo log…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…versions of Percona Server. Bug fixed #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account…didn’t have the path separator at the end. Bug fixed #1181887. A warning is now …. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…MySQL server, of course, cannot risk to block directly all cases. A set of MySQL… # test.test # ######################################################################## # Key redundant ends with a prefix of the clustered index # Key definitions: …
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers to 6.4 [root@percona2... votes 7 Resources configured. Online: [ percona1 percona2 percona3 ] Full list of resources: reader_vip_1 (ocf::heartbeat:IPaddr2): Started percona3 (unmanaged…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with a different schema… mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE tblname IMPORT TABLESPACE Now, you have a old version of… helpful script to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl…
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
… Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can watch a video of his presentation on YouTube…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… copy of Java JRE for your platform You will need a Java driver for your database — I’m using the MySQL Connector… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 2 Comments
… Server for MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release Candidate release of Percona… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it…_dir variable didn’t have the path separator at the end. Bug fixed #1181887. Changed page tracking used to hold the…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done…, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the…-11e2-b985-0800272864ba:1 or 3d3871d1-c3ae-11e2-b986-0800272864ba:4 ? A ‘Last_Executed_GTID’ column would have been useful. In…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding…
