… High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute Units (8 …InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… Gb RAM. The imp param for InnoDB are [root@ng-lg-mdb1 ~]# cat /etc/my.cnf|grep innodb innodb_data_home_dir = innodb_…/mysql/data innodb_buffer_pool_size = 2000M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… with 96 GB RAM when the innodb_buffer_pool_size was set to anything more than 62 GB. I decided to try it with 76 GB. The… G for every 25 G of the buffer pool. This can become significant in the proper innodb_buffer_pool_size estimations when the system has a lot of RAM and you want to have the largest possible innodb_buffer_pool_size. Do…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… if your write working set is, say, 100 GB, then increasing the buffer pool size does not help. PZ: I should note for most… the main one with “innodb_buffer_pool_size=20480Mâ€) while the bulk of the rest (9 GB) is used for the OS cache… 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: How to calculate a good InnoDB log file size
November 21, 2008 By 33 Comments
…post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but … GB of logs. But also realize this: the recovery time depends not only on the total log file size…advice to size the logs as a fraction of the buffer pool size is just wrong. One final note: huge buffer pools or …
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… GB and shows what amount of the space in innodb_log_file corresponds to changed pages in the buffer pool. …innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 64M innodb_buffer_pool_size = 26G innodb_buffer_pool_instances=16 innodb_log_file_size = 2000M innodb…
Post: How long Innodb Shutdown may take
September 2, 2010 By 8 Comments
… dirty buffers. The number of dirty buffers in the buffer pool varies depending on innodb_max_dirty_pages_pct as well as workload and innodb_log_buffer_size and can be anywhere from 10 to 90% in the real life workloads. Innodb_buffer_pool_pages_dirty status… Buffer pool size. This is worse case scenario though it is quite common in practice to see shutdown time of about 1min per GB…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
…,000 M1400 (1400GB Usable) – $18,200 This amounts to $13/GB Second, it is important to compare the performance of Virident… innodb_buffer_pool_size=120GB, 174GB and innodb_flush_log_at_trx_commit=1, 2. The results in this post are for case innodb_buffer_pool_size=174GB and innodb…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 38 Comments
…(R) Xeon(R) CPU 5160 @3.00GHz 6 GB RAM. and mysql with Innodb tables. 100mb of data is available. i have… and innodb_additional_mem_pool_size 16M innodb_flush_log_at_trx_commit 0 innodb_log_buffer_size 8M innodb_buffer_pool_size 1G innodb_log_file_size 24M innodb_thread_concurrency 16 innodb_lock…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… running under CentOS 5.6 on a system with 32 GB of memory: My sysctl.conf looks like this: # Memory optimization… memlock unlimited My my.cnf looks like this: large-pages innodb_buffer_pool_size=4G . If I su to mysql from root and run… HugePages: 110518 11:28:32 InnoDB: Initializing buffer pool, size = 4.0G 110518 11:28:32 InnoDB: Completed initialization of buffer pool If I try and use…
