Re: mysql: unknown variable 'innodb_buffer_pool_size=4G'
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
Subject
Views
Written By
Posted
3846
July 06, 2015 06:05AM
7098
July 06, 2015 07:41AM
Re: mysql: unknown variable 'innodb_buffer_pool_size=4G'
4365
July 06, 2015 10:21AM
2073
July 06, 2015 01:59PM
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.