SOLVED No InnoDB Support Enabled!

[ribo]

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?

 

[sktest123]

this might be a bug with script, try Bug #1565227 “Mysql 5.7 InnoDB support” : Bugs : MySQL Tuning Primer Script

 

[cPanelMichael]

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.

 

[ribo]

Thank you for your answer. Do you know where is the location of tuning primer script in centos to put this patch?

 

[cPanelMichael]

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:

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.

 

[ribo]

I found the location of "tuning-primer.sh" and i added the + lines of the patch and the "No InnoDB Support Enabled!" is gone. Thank you for your help.

 

[cPanelMichael]

Hello,

I'm glad to see that helped. I've marked this thread as solved.

Thanks!