… in Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug… 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 (Alexey…
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… 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 (Alexey…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: xtrabackup_56 binary was… with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log copying…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer …FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log…1169726. For the Debian and the Linux binaries, the –version message which should include…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… fact that for every MySQL restart, the logs are flushed and a new binary log is created, looking at the current binary logs after restoring the snapshot, I know I have to apply mysql…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… so-called “binary log” of events that modify data in the server. The binary log is a real limitation in MySQL. The binary log is necessary not… enabling the binary log reduces MySQL‘s performance dramatically. It is not the logging itself that’s the problem — writing the log is usually not much additional work. It’s ensuring consistency and durability that is expensive. Flushing it to disk…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… the system process list it was quite obvious that page flush daemon was acting out. I/O Pattern was rather awkward… mysql mysql 1073742566 Nov 3 08:35 /var/lib/mysqllogs/db1-bin-log.003234 What is happening here? Apparently, every time current binary log gets…, new binary log is created and, if expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log mutex is…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… code path if XA is disabled ? Many customers do not flush binary log anyway and use single transactional storage engine so they do… so you may not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but obviously you loose point in time recovery and replication. Use innodb_flush_log…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… such setup. There are good reasons to have binary logs on NFS volume – binary logs is exactly the thing you want to survive the… of contention issues in MySQL 5.0 rather than any NAS issues. This number was reachable even with binary log stored on NFS volume. This number is for sync_binlog=0 and innodb_flush_log_at_trx_commit…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… you may want to: relax InnoDB durability (innodb_flush_log_at_trx_commit) disable binary logging if it’s not useful look at the… nature. Q: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I made are valid… good command of SQL query writing and wanted to learn MySQL administration suggest any book or practices. Of course I’m…
