…such as multiple buffer pools on MySQL 5.5 and above ? Also I’m not sure the config file posted …It contains: innodb_log_file_size = 4000M #innodb_log_file_size = 1024M #innodb_log_file_size = 256M innodb_log_files_in_group = 2 As you can see it is 4000M log file with 2 log file in group which is …
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… innodb_buffer_pool_size=6G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
… innodb_buffer_pool_size=3G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb…
Comment: How to calculate a good InnoDB log file size
June 1, 2010 By 38 Comments
… innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 2048M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_log_buffer_size = 8M innodb_thread_concurrency = 8 innodb…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb_log_file_size=400M # Approx 20% of buffer pool innodb…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…-10-112-39-98 log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file_size=64M You can start… SST, you should see this in the error log. 120619 13:20:17 [Note] WSREP: State transfer required: Group state: 77c9da88-b965-11e1…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_log_buffer_size 8388608 innodb_log_file_size 134217728 innodb_log_files_in_group 2 innodb_log_group_home_dir /rdsdbdata/log/innodb innodb_max_dirty_pages_pct 75 innodb_max_purge_lag 0 innodb_mirrored_log_groups 1 innodb…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… captured in the slow log by setting long_query_time to 0. Then for analysis purposes the queries in the slow log were grouped by…, while the buffer pool size is 6G. The value of innodb_max_dirty_pages_pct was set at 90, while the InnoDB log files were sized at 4G…
Post: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
…: innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend 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_in_group…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…Innodb Undo Logs – Fast Restart – Preloading Innodb Buffer Pool – Online DDL – Import/Export for Partitioned Tables – Remote Binlog Backup – Innodb Transportable Tablespaces – New configuration files…
