…MySQL manual, especially the …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…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…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 … 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…/log/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: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…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: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…_table 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…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask… to grow dramatically do not oversize innodb_buffer_pool_size you might find better use for memory available. innodb_additional_mem_pool_size This one does not really…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…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
… 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_log_file_size…
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…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL …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_…
