…: ## 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…
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: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
Hi Chris, try this: innodb_log_file_size = 64M (without the “B” in “MB” string) This works on ….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… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… size in a 5.0.95 MySQL database running on RHEL 5. I add the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file_size = 64MB Then: /sbin/service mysqld stop Then rename…
Comment: How to calculate a good InnoDB log file size
April 24, 2012 By 33 Comments
What if the calculation above shows that I should have an innodb log file size of 1-2 MB? I’m running Percona server on an ec2 small instance with the XFS filesystem for the mysql data directory.
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… better experience on SSD is : innodb_flush_neighbor_pages = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G Versions: MySQL 5… improve throughput in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with innodb_log_file_size=8GB And to aggregate results and…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 69 Comments
…: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_trx_commit = 1 innodb_lock_wait…
Comment: What to tune in MySQL Server after installation
April 15, 2012 By 116 Comments
… tips. BUT: Please add a big warning that just changing “innodb_log_file_size” is not enough (see other comments for more info)! Since…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…. If you are using InnoDB, it is also important that your transaction logs (ib_logfile*) …statement at position 336797160: mysql> show binary logs; +——————+———–+ | Log_name | File_size | +——————+———–+ … | mysql-bin.000022 | 336797725 | | mysql-bin.000023 | 107…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB…timeouts, applications often don’t handle or log this error appropriately. The pmp-check-…max_connections problems (the use of fixed-size connection pooling, for example, which can sometimes…
