… Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5… with its binary log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release… page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t… #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: …mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log … # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion Enabling GTID-…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60…Percona Server 5.5 release (currently Percona Server 5.5.31-30.3). New Features: Percona Server has implemented Log …I/O error if changed page tracking is enabled. Bug fixed #1184517. Missing path separator between the…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data …seems to be on par with having the general log enabled. The flexibility comes from the three variables that … #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings… ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… in Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #1162085… contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… in Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #1162085… contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… 5.1.68 -14.6 on April 19, 2013 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68-14.6, a MySQL alternative, is… in Percona Server 5.1.66-14.2 which could cause a server to hang when binary log is enabled. Bug fixed #1162085…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users … go through these basics. log_slave_updates is REQUIRED You need to have log_slave_updates enabled on the cluster node…Although the previous bug has been fixed on latest release (5.5.30-23.7.4), table without PK imposes an…
