No InnoDB Support Enabled!

ribo

• May 13, 2018 12:04

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

  • May 14, 2018 06:39

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

  0
• 

  cPanelMichael

  • May 14, 2018 17:15

  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.

  0
• 

  ribo

  • May 14, 2018 17:33

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

  0
• 

  cPanelMichael

  • May 15, 2018 14:11

  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:

  0
• 

  ribo

  • May 16, 2018 19:31

  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.

  0
• 

  cPanelMichael

  • May 16, 2018 20:05

  Hello, I'm glad to see that helped. I've marked this thread as solved. Thanks!

  0

Please sign in to leave a comment.