Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SOLVED No InnoDB Support Enabled!

Discussion in 'Database Discussion' started by ribo, May 13, 2018.

  1. ribo

    ribo Well-Known Member

    Joined:
    Oct 15, 2015
    Messages:
    60
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    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?
     
  2. sktest123

    sktest123 Well-Known Member

    Joined:
    Jan 31, 2017
    Messages:
    92
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    kochin
    cPanel Access Level:
    Root Administrator
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,298
    Likes Received:
    1,765
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  4. ribo

    ribo Well-Known Member

    Joined:
    Oct 15, 2015
    Messages:
    60
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Greece
    cPanel Access Level:
    Root Administrator
    Thank you for your answer. Do you know where is the location of tuning primer script in centos to put this patch?
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,298
    Likes Received:
    1,765
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  6. ribo

    ribo Well-Known Member

    Joined:
    Oct 15, 2015
    Messages:
    60
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Greece
    cPanel Access Level:
    Root Administrator
    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 likes this.
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,298
    Likes Received:
    1,765
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thanks!
     
Loading...

Share This Page