Ubuntu – How to permanently increase innodb_buffer_pool_size on Ubuntu

bufferinnodbmemoryMySQLUbuntu

I have read lot of posts & manuals to try to find out how to increase memory in MySQL 5.6 on Ubuntu, which say there are 3 methods:

  1. By editing innodb_buffer_pool_size in the my.cnf
  2. By command line option on starting MySQL
  3. Dynamically with SQL commands.

I assume 2 and 3 will be lost when MySQL is restarted, which leaves 1.

The problem is, there are no such settings in my /etc/mysql/my.conf.

The string "inno" does not exist in the conf file, nor does "buffer_size" or "buffer-size" (but "key_buffer" is in there).

I installed it via:

# apt-get install mysql-server-5.6

Any ideas where I can change the value?

Did I somehow install MySQL without the InnoDB engine?

Am I looking in the wrong file?

There are some other .cnf files under /etc/mysql, but they have nothing like innodb in them either.

mysql> show variables like 'inno%'
:
innodb_buffer_pool_size                  | 134217728              |

So it looks like InnoDB is installed, I just can't find where its config file is.

Any help appreciated.

Best Answer

Here's what worked for me (ubuntu 19, mysql 8):

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

add in this at the bottom of the file 

innodb_buffer_pool_size        = 8G

save and exit. restart MySQL.

sudo systemctl restart mysql
Related Topic