MySQLTuner - innodb_buffer_pool_size

Forum for questions and support relating to the 1.28.x releases only.
Locked
Biggus
Posts: 96
Joined: Mon Nov 18, 2013 9:15 am

MySQLTuner - innodb_buffer_pool_size

Post 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.
bbunge
Posts: 2951
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: MySQLTuner - innodb_buffer_pool_size

Post by bbunge »

Guide in process. Should be posted by tonight.

bb
bbunge
Posts: 2951
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: MySQLTuner - innodb_buffer_pool_size

Post 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
Locked