… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…. Percona XtraBackup would fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source… 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
… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… the log copying thread. Percona XtraBackup now stores the GTID value in the xtrabackup_binlog_info when doing the backup of MySQL… 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 Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… 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…
Comment: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
On MySQL 5.5+ I would think its preferable to use FLUSH /*!50503 SLOW */ LOGS, rather than a general FLUSH LOGS which will touch a lot of other (likely more expensive) log files as well.
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… log but not actually flush the log to disk at commit. By this means you are ensuring that in the event of a MySQL… log buffer to log about once a second and flush */ innodb_flush_log_at_trx_commit = 1 /* Write log buffer to log and flush to disk */ innodb_flush_log_at_trx_commit = 2 /* Write log buffer to log and flush…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But ….commanual innodb_file_per_tableblogpercona.commanual innodb_flush_log_at_trx_commitblogpercona.commanual innodb_flush_methodblogpercona.commanual innodb_force_recoveryblogpercona.commanual …
Post: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
….com/2011/09/18/disaster-mysql-5-5-flushing/ http://www.mysqlperformanceblog.com/2011/03/31/innodb-flushing-a-lot-of-memory-and… innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_buffer_pool_size = 150G innodb_log_file_size = 4G innodb_log_files…
Post: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
… the log buffer is written. This is interesting. It means that the durability setting can skew the results: if innodb_flush_log_at… different between the 2 methods. Even stranger, the innodb_os_log_written method consistently gave higher numbers than the LSN method… innodb_flush_log_at_trx_commit is set to 1 or 2 (again, thanks Alexey): Transaction 1 writes 100 bytes to the log…
Post: Adaptive flushing in MySQL 5.6 - cont
September 10, 2012 By 13 Comments
This is to continue my previous experiments on adaptive flushing in MySQL 5.6.6. Now I am running Ubuntu 12.04… per 60 sec, and we could claim that adaptive flushing algorithm in MySQL 5.6.6 works as expected. The devil as… for Checkpoint age Checkpoint reaches maximal value ( ~75% of 8GB logs) and stays in this level. As I understand checkpoint age…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… to have a single separate dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads…_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb… to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important…
