…increasing…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_block_size…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
….6.11 spent in LRU_scan. I tried to increase innodb_lru_scan_depth variable to 8k,16k,32k but that had no notably… how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool…to simply check it. Start MySQL With 10GB Innodb buffer pool for example and see how…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…to recover longer. Buffer Pool Size This affects recovery time from two parts aspects – first if you have small buffer pool…to be done in the background. In the future to increase…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… sure to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated that memory to into key_buffer_size. The… are books that describe how to use one technology or the other, and some may compare one technology to the other, but typically…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…set is, say, 100 GB, then increasing the buffer pool size does not help. PZ: I should …to the first file in the log file group? HT: InnoDB writes the checkpoint information to the first file. Q31: How…this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much more sensitive to buffer size compared to…to increase sort_buffer_size even if you have 64GB of memory to…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
… because amount of queries increased dramatically or may be because queries changed their plans. Do the sizing This especially works … innodb_buffer_pool_size (while having innodb_flush_method=O_DIRECT) and see how performance depends on buffer size so you get and understanding what Memory-To-…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…innodb_buffer_pool_size, like 13GB, 52GB, and 144GB, for testing the tpcc-mysql database with size 100G. This was needed in order to…increasing innodb_log_file_size may help, but check checkpoint age history to…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…pool_size=16M innodb_buffer_pool_size=15G 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…InnoDB, but nothing special to be proud of. We definitely we will look how to…
