…’ keeps increasing I have disabled the query cache by set global query_cache_size = 0; All this on a fairly decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…. and transactions for this workload are: $ID=monotonically increasing ID $K=rand(0,10000) // distributed by pareto distribution…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
… 5.6.11 spent in LRU_scan. I tried to increase innodb_lru_scan_depth variable to 8k,16k,32k but that… 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…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is… for other stuff, and you can increase it a bit to be on the safe size and scale appropriately. The third important…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
… used innodb_buffer_pool_size=26G 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=4G innodb_adaptive_checkpoint=keep_average innodb_thread_concurrency=0 innodb_flush…, in second run it is 49130.13 NOTPM, that is increase is 1.28x, and I can’t say this is…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… your write working set is, say, 100 GB, then increasing the buffer pool size does not help. PZ: I should note for most application… (of which Mysql is the main one with “innodb_buffer_pool_size=20480Mâ€) while the bulk of the rest (9 GB) is… the post on this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi…
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… not mainstream these days but as number of cores is increasing now at the same pace as CPU frequency before we…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… used different values for innodb_buffer_pool_size, like 13GB, 52GB, and 144GB, for testing the tpcc-mysql database with size 100G. This was needed… performance gain. If you already use Percona Server, then increasing innodb_log_file_size may help, but check checkpoint age history to see…
Post: Innodb Fuzzy checkpointing woes
May 10, 2006 By Leave a Comment
… same LSN range scheduled for flush and Innodb might end up flushing most of buffer pool pages.     Now… small (ie only size of allocated buffer pool size) this might never happen. This is very unusual case of increasing your buffer pool size actually may decrease… 500 IOs/sec Innodb will not catch it as such and will not use it to flush dirty buffers aggressively and perform…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of memory is a safe… for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed needs but 256M… performance innodb_log_buffer_size=4M 4M is good for most cases unless you’re piping large blobs to Innodb in this case increase it…
