Page 1 of 1

MySQLTuner - innodb_buffer_pool_size

Posted: Mon Oct 12, 2015 4:27 pm
by Biggus
Hi,

I've just built a new Ubuntu 14.04 ZM 1.28.2 box and noticed in the easy instructions regards changing the innodb_buffer_pool_size.

Does anybody have any step by step instructions on how to do this? I am still new to Ubuntu so it would be helpful if somebody could advise.

Re: MySQLTuner - innodb_buffer_pool_size

Posted: Mon Oct 12, 2015 4:52 pm
by bbunge
Guide in process. Should be posted by tonight.

bb

Re: MySQLTuner - innodb_buffer_pool_size

Posted: Mon Oct 12, 2015 8:53 pm
by bbunge
I've decided to keep the database tune up a bit generic. Located here:
http://www.zoneminder.com/wiki/index.ph ... cks.2FTips

For your Ubuntu 14.04 you need to edit /etc/mysql/my.cnf like this:

sudo nano /etc/mysql/my.cnf

After you have made the changes:

Ctrl + O to save

Ctrl + X to exit

For Ubuntu we also have:

http://www.zoneminder.com/wiki/index.ph ... _on_Ubuntu