… increasing ID …how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we will need to…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb…
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… Configurations and 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…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…buffer pool, so there are no reads from disk. However, there is write activity stemming from the fact that this is using InnoDB…increases in both operations, there are some tradeoffs to consider: Cost of additional memcached hardware Cost of operations time to…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… is usually much better to simply check it. Start MySQL With 10GB Innodb buffer pool for example and see how large RSS and VSZ get in “ps” output on Unix Systems. If it gets to 12GB when you need 2GB for other stuff, and you can increase it a bit to be on the…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…buffer pool when recovery is complete but again this does not normally take major part of recovery time. It is worth to note Innodb… seems to be done in the background. In the future to increase recovery…to handle and crash Innodb few times to see how long it takes Innodb to recover. I’d recommend to…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… allocate buffers in what I hope was a realistic way. For instance, when testing the InnoDB FT index, I made sure to increase innodb_buffer_pool_size to… are books that describe how to use one technology or the other, and some may compare one technology to the other, but typically…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…innodb_log_buffer_size is optimal – if you see more than 30% of log buffer size being unflushed you may want to increase…buffer pool. Finally you can see buffer pool hit ratio which measures buffer pool efficiency. 1000/1000 corresponds to 100% hit rate. It is hard to tell what buffer pool…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to increase size of your Innodb log files to be able to use a lot of memory for write buffering…to the first file in the log file group? HT: InnoDB writes the checkpoint information to the first file. Q31: How… this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several …
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: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…buffer pool pages are flushed down the to the tablespace. If Innodb stops (read: crashes) with dirty buffer pool pages, Innodb recovery must be done to… on these numbers, we can determine how many bytes back in…buffers and they are hitting their max checkpoint age. The way this increases dirty buffer…
