…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… bad in standalone Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something … ‘killed_troll’”; } change your schema In Example 2, above, how above moving the ‘joined’… take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
…innodb_flush_log_at_trx_commit = 0 /* Write 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: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
… when the log buffer is written. This is interesting. It means that the durability setting can skew the results: if innodb_flush_log_at_trx_commit is… look at an example when innodb_flush_log_at_trx_commit is set to 1 or 2 (again, thanks Alexey): Transaction 1 writes 100 bytes to the log buffer At commit, InnoDB…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…innodb_buffer_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb…. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important to remember that 5.6.2 multiple…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…368, undo log entries 1 MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) …your log file requires. Note depending on your innodb_flush_log_at_trx_commit value your log writes may be more or less expensive. If innodb_flush_logs_at_trx_commit=2 log writes…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
…trx_commit=0 : innodb_flush_log_at_trx_commit = 0 and no binary logs trx_commit=1 : innodb_flush_log_at_trx_commit = 1 and no 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 trx_commit…
