…(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…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
…/second (more is better), the X axis is the size of innodb_buffer_pool_size: Let me point out three interesting characteristics about this benchmark: The A arrow is when data fits completely in the buffer pool… B and C may be located in differently. Raw results: Buffer pool, GB FusionIO Intel SSD RAID 10 2 450.3 186.33…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 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: Drop table performance
April 20, 2011 By 22 Comments
… have a big buffer pool, it may be a significant issue. This can get especially painful, as during this operation InnoDB holds the…. Hardware was the Cisco UCS C250, the InnoDB buffer_pool size was 144GB, and I filled the buffer pool with different amounts of data: 104GB, 52GB… we see, all three versions are affected by a bigger buffer pool: The more memory used, the slower DROP TABLE operates. MySQL…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… to remove warm-up phase Parameters to vary: we vary innodb_buffer_pool_size:25, 50, 75GB to have different memory/data ration. And… internals + flushing logic. Now, all these results are received with innodb_flush_log_at_trx_commit=2, which in comments to… post was called cheating. So I ran another round with innodb_flush_log_at_trx_commit=1 to see what kind…
Comment: Heikki Tuuri to answer your in depth Innodb questions
October 1, 2007 By 51 Comments
… googling. “What is the good way to split memory between INNODB buffers and OS?” Of course this depends on all kinds of… server has around 21 GB of memory used for applications (of which Mysql is the main one with “innodb_buffer_pool_size=20480M”) while the bulk of the rest (9 GB) is used for the OS cache…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
… to remove warm-up phase Parameters to vary: we vary innodb_buffer_pool_size: 13, 25, 50, 75GB to have different memory/data ration…
Comment: 5.0.84-build18 Percona binaries
August 24, 2009 By 4 Comments
… work ok. It runs with the same my.cnf except innodb_fast_recovery=true. The recovery time on a hw failure… Tablespace 2x256K ib_logfile 20 GB innodb_buffer_pool_size on dual quad core intel E5345 32 GB RAM 3* 16*142 GB SAS Disks 15krpm Frank
Comment: Choosing innodb_buffer_pool_size
April 12, 2010 By 39 Comments
Hi Peter, I have a dedicated server with 2 GB RAM running InnoDB and have a large database that is roughly 10 GB. How high should I set innodb_buffer_pool_size to be? Thanks, Paul
