… OS_THREADS) So InnoDB uses: innodb_buffer_pool innodb_additional_mem_pool_size innodb_log_buffer_size adaptive index hash, size= innodb_buffer_pool / 64 system dictionary hash, size = 6 * innodb_buffer_pool_size / 512 memory for… for innodb: innodb_buffer_pool_size + innodb_log_buffer_size + innodb_additional_mem_pool_size + 812 / 16384 * innodb_buffer_pool_size + OS_THREADS * 368 For simplicity we can use: 812 / 16384 * innodb_buffer_pool_size ~~ innodb_buffer_pool_size / 20…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… need to consider the added memory for InnoDB: specifically, the buffer pool. (There’s also an innodb_additional_mem_pool_size but it’s typically set pretty… actually promise to fit within innodb_additional_mem_pool_size, by the way. If it needs more it will allocate it. innodb_additional_mem_pool_size is just a handy…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size=32M innodb…_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size=32M innodb…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…=2 innodb_file_per_table=1 innodb_doublewrite=0 # Set buffer pool size to 50-80% of your computer’s memory innodb_buffer_pool_size=4G innodb_additional_mem_pool_size=20M # Set the log file size to about 25% of the buffer pool size innodb_log_group_home_dir = /mnt/log_mysql innodb…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
….log innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path = ibdata1:100M:autoextend set-variable = innodb_buffer_pool_size=100M set-variable = innodb_additional_mem_pool_size=10M innodb_flush_log_at_trx_commit=1 #skip-innodb…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…indexblogpercona.commanual innodb_additional_mem_pool_sizeblogpercona.commanual innodb_autoextend_incrementblogpercona.commanual innodb_autoinc_lock_modeblogpercona.commanual innodb_buffer_pool_instancesblogpercona.commanual Innodb_buffer_pool_pages_datablogpercona.commanual Innodb_buffer_pool_pages…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… I used innodb_buffer_pool_size = 2G and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log…
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_at_trx_commit = 1 innodb_lock…
