… $ID=monotonically non-decreasing ID $K=rand(0,10000) // distributed by pareto distribution BEGIN INSERT …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: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…your hotspots were really bad in standalone Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something besides 1 and suddenly…in memcache or redis and only flushing to the database periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements SET …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend 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…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona …100M 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_…
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: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
…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: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o’s: 0, sync i/o’s: 0 Pending flushes (fsync) log: 0; buffer pool: 0 17909940… 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…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…-back cache is disabled), innodb_flush_log_at_trx_commit=1 and sync_binlog=1 or in tabular format: Threads Nofix Group Commit fix 1 21.51… Group Commit Fix in an upcoming Percona Server release. It is also interesting to see how Flash cards will handle innodb_flush_log_at_trx_commit=1… the similar with writeback cache enabled thread trx=1, No binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 382.39…
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 about once per second */ (About once a second is related to the fact the flush and…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages per flush. That means that under a heavy write load, a new flush… way to get good performance is to set innodb_flush_log_at_trx_commit=2, that is, to flush the log to the disk only once per second… number of users who had serve regressions in 5.0 because of group commit being broken. Most do not have RAID with…
