I want to improve the perfomance of our MySQL databases .
Every article says that we should adjust some settings in my.ini
Original settings:
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
intended changes:
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=4M
innodb_buffer_pool_size=2GB
innodb_log_file_size=128M
But every time we change this settings MySQL stops working and doesnt restart
What is the problem? what we should do to optimize settings?
Thanks
Every article says that we should adjust some settings in my.ini
Original settings:
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
intended changes:
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=4M
innodb_buffer_pool_size=2GB
innodb_log_file_size=128M
But every time we change this settings MySQL stops working and doesnt restart
What is the problem? what we should do to optimize settings?
Thanks