…innodb_log_buffer_sizeblogpercona.commanual innodb_log_file_sizeblogpercona.commanual innodb_log_files_in_groupblogpercona.commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write_requestsblogpercona.commanual Innodb_log…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…settings: innodb_buffer_pool_size=24G 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…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…is a variable in SHOW STATUS, innodb_buffer_pool…innodb_log_file_size * innodb_log_files_in_group. If you have these conditions and observe intensive writes, InnoDB…InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…5.5.24 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_flush_method=… set certain rules for which certain join algorithms are best and then use that algorithm by making use of the variable…
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: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_max_dirty_pages_pct = 90 innodb_flush_method = O_DIRECT (the followings are XtraDB specific general settings) innodb… contention. The current XtraDB has the variable to tune the contention. innodb_stats_update_need_lock = 0 (default 1…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’, ’0′ ‘Com_select’, ’378247551′ ‘Com_set_option’, ’285487367′ ‘Com_show_…show_tables’, ’2842′ ‘Com_show_variables‘, ’176825′ ‘Com_show_warnings’, ’8′…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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… devices, volume groups, and logical volumes….innodb_log_file_size. I won’t give you a full rundown over every option in the file… format the second set of values up beside the first set… in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file…Variable_name | Value | +——————–+——-+ | wsrep_cluster_size | 3 | +——————–+——-+ 1 row in set (0.00 sec) When all nodes are started, we will set…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…innodb_additional_mem_pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log…
