…innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 536870912 xtrabackup: use O_DIRECT >> log scanned up to (3…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_read_io_threads = 16 innodb…to increase it to 70% ? It seems 70%Â is too big, and now we again hit the limit set by innodb_log_file…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… Used Query OK, 3 rows affected (0…to block other queries for a significant amount of time. Setting innodb…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
…innodb_log_file_size * innodb_log_files_in_group. If you have these conditions and observe intensive writes, InnoDB is using LRU list flushing. So why is it important to…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… available since MariaDB 5.3, but I will …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…in both test cases. Since in Test B we have a limited set of rows in the supplier table (left operand) to join to…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb… set to WT cache: The second is with WB cache: I couldn’t figure out what exactly happened with setting #3…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…Com_rollback’, ’4666272′ ‘Com_savepoint’, ’0′ ‘Com_select’, ’378247551′ ‘Com_set_option’, ’285487367′ ‘Com_show_binlog_events’, ’0′ ‘Com_… 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…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…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=4G innodb_log_block_size=4096 innodb_thread_concurrency=0 innodb…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…innodb_log_buffer_size = 8M innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = 16 innodb_open_files = 20000 innodb_flush_method = O_DIRECT innodb…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…innodb_log_buffer_size = 8M innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = 16 innodb_open_files = 20000 innodb_flush_method = O_DIRECT innodb…
