…: ## 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_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I set to… of 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait… 120502 11:51:16 InnoDB: Log file ./ib_logfile1….cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql]#
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
… innodb innodb_data_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/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…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, …ps.log ps aux | grep mysqld >> ps.log …Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) … memory allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 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… logs, or relay logs, Innodb Transactional Logs also like to be cached otherwise OS will need to do reads to serve writes to these log files…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…_average innodb_read_ahead=none For MySQL 5.5.8, I used: innodb_log_file_size=2000M (innodb_log_files_in_group=2), as the maximal available setting innodb_buffer_pool_instances=8 (for a 13GB buffer pool); 16 (for 52 and 144GB buffer pools), as…
Comment: Choosing innodb_buffer_pool_size
April 19, 2009 By 38 Comments
[...] UPDATE 关于它具体的查看http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/ innodb_log_file_size [...]
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… innodb_buffer_pool_size=24G 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_log_block_size=4096 innodb…
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_log_files_in_group=2 innodb_log_file_size=512M innodb_status_file…
