… buffers which are allocated at start and always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size… thread or global memory allocations which are not tuned as buffers. Watch for these especially now with many …
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
…innodb_additional_mem_pool_size 16M innodb_flush_log_at_trx_commit 0 innodb_log_buffer_size 8M innodb_buffer_pool_size 1G innodb_log_file_size 24M innodb_thread_concurrency 16 innodb…
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: 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: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…PAGE_SIZE / 2) Q5: When Innodb free space becomes available for use within same object? When does Innodb… user to tune the checkpointing values. HT: Hmm… we could tune the way InnoDB does the buffer pool flush…Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…buffer pool (with very small additional pool and log buffer) and total amount of memory allocated by Innodb… database size you need to check if there are any restrictions on Innodb Buffer Size you can… Innodb Buffer Pool and few other buffers, which may have other performance benefits as well. Tuning …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_HISTORY_LONG_SIZE | 10000 | 100 | | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | 1000000 | 1724 | | PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | 100000 | 2223 | | INNODB_LOG_FILE_SIZE | 5242880… | | BACK_LOG | 50 | 80 | | OPEN_FILES_LIMIT | 1024 | 5000 | | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144… is one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON by default…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… for Percona Server: innodb_log_file_size=4G (innodb_log_files_in_group=2) innodb_flush_neighbor_pages=0 innodb_adaptive_checkpoint=keep_average innodb_read_ahead=none… 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… if you are looking for high MySQL performance, and we tune Percona Server to get the most from such hardware. Actually…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
…innodb_buffer_pool_size = 16G innodb_max_dirty_pages_pct = 90 innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_io_capacity = 4000 innodb_read_io_threads = 8 innodb…
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 …resolve is easy to miss, as is the absence of innodb_log_file_size. I won’t give you a full rundown …big units, so it’s hard to read. If the InnoDB buffer pool is set to 22GB, it’s much easier …
