I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there … to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow…_Ahead which is not available in MySQL 5.5 (different version is added back in MySQL 5.6) so I tried that…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end… binary logs trx_commit=0 & binlog : innodb_flush_log_at_trx_commit = 0 and binary logs trx_commit=1 & binlog : innodb_flush_log_at_trx_commit = 1 and binary logs…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ… record binary log position which is done by running SHOW MASTER STATUS – This is binary log position you’ll need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…flushed the logs before I did this, everything in the binary log so far comes from these statements. Let’s look at the binary logs…’s in the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name: mysql-bin.000011 Pos…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… of sync with binary log and it is not easy to find which. I’m surprised to read enabling binary log drops update performance. I guess Jeremy speaks about enabling binary log and setting sync_binlog option which… which make certain disks to flush their cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… these major components: Percona XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5…-long-queries to avoid nasty problems with “FLUSH TABLES WITH READ LOCK” –compress, compresses … mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… to summarize: the fix improves performance substantially when both innodb_flush_log_at_trx_commit=1 and sync_binlog=1 options are… comments there is also result to compare binary logs enabled and disabled. All results are for binaries with group commit fix. Results with….85 2004.13 1669.11 As you can see, enabling binary logs with system without writeback cache impacts performance significantly. And the…
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… disk flushes and get better InnoDB performance. Having innodb_support_xa enabled on a replication master—or on any MySQL server where binary logging is in use—ensures that the binary log does not get out of sync…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
We made new binaries for MySQL 5.0.67 build 10 which include next fixes: We addressed concerns about potential logging and statistics… were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running… | GPL | This patch contains fixed (control_flush_and_merge_and_read, control_io-threads, adaptive_flush) | | innodb_show_hashed_memory.patch | Adds…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… and bring your database to consistent state. Depending on innodb_flush_lot_at_trx_commit setting you may lose few last… use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is…
