…for throughput in this scenario, you will tune innodb_concurrency_tickets to the 99th percentile …size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_files_in_group=2 innodb_log_file_size=1900M innodb…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…innodb_buffer_pool_size = 16G innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 128M innodb_log_file_size = 512M innodb_log_files…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…, innodb_io_capacity, and innodb_log_file_size do not matter, and changing these settings won’t help. Ironically, these settings are most important for tuning…/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size are important for tuning…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much more sensitive to buffer size…memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive workloads especially for large data sets. Larger sizes …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed needs but 256M… and good performance innodb_log_buffer_size=4M 4M is good for most cases unless you’re piping large blobs to Innodb in this… on Innodb ones today. You can check about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… benchmark (100W ~ 10GB of data, 12G innodb_buffer_pool_size, 1G innodb_log_file_size), MySQL 5.5.10 with innodb_adaptive_flushing=ON (default)). The problem… increase innodb_io_capacity and decrease innodb_max_dirty_pages_pct so as to have fewer dirty pages. But I call that tuning…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… usage Innodb tables may increase in size significantly due to fragmentation. Usage Differences What works well for MyISAM may not work for Innodb… do not want to try to run Innodb or XtraDB with them. Second Innodb is tuned to be ACID by default – if you… to check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log_file_size. There are a lot more options for fine tuning but make…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem_pool_size = 20M innodb_log_file_size = 1600M innodb_log_buffer_size = 16M innodb_flush_log…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…size=20M # Set the log file size to about 25% of the buffer pool size innodb_log_group_home_dir = /mnt/log_mysql innodb_log_file_size=1G innodb_log_buffer_size=64M innodb_flush_log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… can work with systems that are at any level of tuning, from completely untuned to a system that’s already had… is the absence of innodb_log_file_size. I won’t give you a full rundown over every option in the file. But again, you… the error log is interesting and needs to be investigated. You might find that there are InnoDB tables whose .frm files exist but…
