…/mysql/ innodb_log_arch_dir = /var/lib/mysql/ innodb_buffer_pool_size = 2048M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_log_buffer_size = 8M innodb_thread_concurrency = 8 innodb_flush_log_at…
Comment: How much memory can MySQL use in the worst case?
February 22, 2009 By 17 Comments
…have any Innodb related memory usage like buffer pool, redo buffer, additional mem pool etc. you might want to first look into that. use either show innodb status show variables like ‘inno%’; also what your key buffer size, sort buffer size and query cache setting? …
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 skip…
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_log_buffer_size=8M innodb…
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_lock…
Comment: How to change innodb_log_file_size safely
March 18, 2013 By 17 Comments
… innodb setting in my local machine. 1) shutdown mysql 2) change the following parameters in my.ini innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 8M innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_fast_shutdown = 1 3) rename the…
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
…_cache_size=0 \ –innodb_data_file_path=ibdata1:100M:autoextend \ –innodb_buffer_pool_size=6GM \ –innodb_additional_mem_pool_size=20M \ –innodb_log_file_size=128M \ –innodb_log_files_in_group=2 \ –innodb_log_buffer_size=8M \ –innodb_flush_log_at_trx_commit=2 \ –innodb_thread…
Comment: How much memory can MySQL use in the worst case?
February 13, 2009 By 17 Comments
… game servers). @Baron, Here is my mem status: Total memory allocated 8751883484; in additional pool allocated 20926208 Buffer pool size 458752 … Which mean per your formula… 1.5 week of uptime, ouch. We have about 300 innodb tables. But about 20 of them are truncated every 5s…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… a single test, innodb_plugin.innodb_bug53674. The test … mem_heap_create_block (mem0mem.c:333) ==9090== by 0x6B07D3B: buf_pool…buffer pool stats, the I/O stats might be slightly smaller than they should be. ==9090== Possible data race during write of size… not-so-minor. Additionally, I’d consider …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… OK with default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb buffer pool caches both data and… 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 affect…
