Skip to main content
Solved

Setting innodb values in my.cnf Ubuntu 18.04


honestpuck
Forum|alt.badge.img+11

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?

Best answer by ryan_ball

@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 original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+13
  • Valued Contributor
  • 389 replies
  • January 8, 2019

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?


Forum|alt.badge.img+18
  • Contributor
  • 475 replies
  • Answer
  • January 8, 2019

@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
Forum|alt.badge.img+11
  • Author
  • Contributor
  • 48 replies
  • January 8, 2019

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings