Setting innodb values in my.cnf Ubuntu 18.04

honestpuck
Contributor

Installing JPS onto an Ubuntu 18.04 VM.

I have found /etc/mysql/mysql.cnf but it only contains two include lines.

I added

innodb_buffer_pool_size=5500M
innodb_file_per_table=1

At the point mysql refused to start. Removing the lines allowed it to start again.

Suggestions?

1 ACCEPTED SOLUTION

ryan_ball
Valued Contributor

@honestpuck The file you want is /etc/mysql/mysql.conf.d/mysqld.cnf on 18.04.
Remove it from what you used initially and add it there.

I commented about this in the following article:
https://www.jamf.com/jamf-nation/articles/542/creating-the-jamf-pro-database
Jamf should update the article or at least note this.

View solution in original post

3 REPLIES 3

kerouak
Valued Contributor

are you sure that's the correct file??

I use RedHat and my file is located at /etc/my.cnf

possibly try searching for my.cnf as opposed to mysql.cnf?

ryan_ball
Valued Contributor

@honestpuck The file you want is /etc/mysql/mysql.conf.d/mysqld.cnf on 18.04.
Remove it from what you used initially and add it there.

I commented about this in the following article:
https://www.jamf.com/jamf-nation/articles/542/creating-the-jamf-pro-database
Jamf should update the article or at least note this.

honestpuck
Contributor

@ryan.ball They definitely need to update the article. I might raise it somewhere.