SOLVED No InnoDB Support Enabled!

ribo

Well-Known Member
Oct 15, 2015
66
2
8
Greece
cPanel Access Level
Root Administrator
Hello, i updated from mysql 5.6 to mysql 5.7 . I want to tune it and i run tuning primer and it shows "No InnoDB Support Enabled!" Is it not enabled by default? Is tuning primer works well for mysql 5.7 and what must i have to tune it well for a Vps 4G?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
Hello,

It looks like this is a bug with the tuning script you are using. The link in the previous post should help.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
Thank you for your answer. Do you know where is the location of tuning primer script in centos to put this patch?
Hello,

You'll need to search your system for the tuning-primer.sh file, as I don't believe it comes included with CentOS by default. Here's a command you can use to search for that file:

Code:
find / -name "tuning-primer.sh"
Additionally, when modifying this file to add the patch, note the lines with the "+" symbol in the patched file show you which lines to add to this file, and where to add them:

https://launchpadlibrarian.net/251274960/5.7.patch

Thank you.