MySQL Forums
Forum List  »  InnoDB

Re: mysql: unknown variable 'innodb_buffer_pool_size=4G'
Posted by: Derrick Saunders
Date: July 06, 2015 10:21AM

Hi. Thanks, that worked. I moved the settings below to the [mysqld] section, got a "failed to start" error, determined that my "innodb_log_file_size" configuration was causing the failure, commented it out, and now it's running


innodb_buffer_pool_size = 4G
innodb_additional_mem_pool_size = 500M
#innodb_log_file_size = 30M
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 1

However! I don't see a performance improvement on my inserts - which is the reason for my re-configuration efforts.

Should I start a new thread, for the actual performance configuration issue? (And should I change to a different sub-forum?)

thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysql: unknown variable 'innodb_buffer_pool_size=4G'
4365
July 06, 2015 10:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.