… 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…@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]#
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… used: ## 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: 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 … recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it is quite difficult… 32M x 4 = 128M innodb_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT…
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…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 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…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but… simple script: while true do date >> ps.log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related… *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB NAME: #sql516_1c42_2 TABLE_ROWS: 0 AVG_ROW_LENGTH…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… SHOW ENGINE INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries… need to create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except… information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the…
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.
Comment: What to tune in MySQL Server after installation
April 15, 2012 By 116 Comments
…. BUT: Please add a big warning that just changing “innodb_log_file_size” is not enough (see other comments for more info)! Since…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7… changed, 473733 insertions(+), 210435 deletions(-) The size of the Drizzle kernel (drizzled directory in…tables (similar to MySQL), RabbitMQ, regex policy, logging to syslog, authentication via LDAP. This …
