…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…values. innodb_flush_log_at_trx_commit Crying about Innodb being 100 times slower than MyISAM ? You probably forgot to adjust this …
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
…and 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_lock…again query_Cache=64M. Can any body suggest me to adjust the configuration to keep my process time same as in…
