…INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW INNODB…log files. By monitoring log sequence number and value up to which logs have been flushed you can check if your innodb_log_buffer_size…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to very significant ones. Also do not forget you may need to increase size of your Innodb log files to be able to…file in the log file group? HT: InnoDB writes the checkpoint information to the first file. Q31: How often or what is the pattern of these first log file…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…size you would not loose much anyway. You also may choose to set buffer pool as if your database size…file, binary 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 as IO to the log files…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
…’/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be using any other conf file other….old /etc/my.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: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_log_buffer_size 8388608 innodb_log_file_size 134217728 innodb_log_files_in_group 2 innodb_log_group_home_dir /rdsdbdata/log/innodb innodb_max_dirty_pages_pct 75 innodb_max_purge_lag 0 innodb_mirrored_log…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data_file_path = ibdata1:10M:autoextend innodb_buffer_pool_size = 30G innodb_log_buffer_size = 8M innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…size=256K #*** INNODB Specific options *** innodb_additional_mem_pool_size=20M innodb_flush_log_at_trx_commit=0 innodb_log_buffer_size=4M innodb_buffer_pool_size=304M innodb_log_file_size=152M innodb…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL…set (0.00 sec) Innodb Memory Usage Finally it is often helpful to check how much memory Innodb…File…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…how to properly build the server to…MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb…log_write_low asserts that it holds the log system mutex, and log…size 8 at 0x6e26200 by thread #1 ==9090== at 0x6B77778: os_file…
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
…of xtrabackup1.2 to do the incremental backup, have a error.how to resovle it? OS: centos , MYSQL :MYSQL 5.1….xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2097152 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set …
