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?
     
    #1 ribo, May 13, 2018
  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
    #2 sktest123, May 14, 2018
  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.
     
    #3 cPanelMichael, May 14, 2018
  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?
     
    #4 ribo, May 14, 2018
  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.
     
    #5 cPanelMichael, May 15, 2018
  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.
     
    #6 ribo, May 16, 2018
    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!
     
    #7 cPanelMichael, May 16, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - InnoDB Support Enabled
  1. brt

    Change InnoDB from Antelope to Barracuda?

    brt, May 20, 2018 at 11:49 PM, in forum: Database Discussion
    Replies:
    1
    Views:
    62
    cPanelMichael
    May 21, 2018 at 2:29 PM
  2. cPanelResources

    Tutorial InnoDB Corruption Repair Guide

    cPanelResources, May 10, 2018, in forum: Database Discussion
    Replies:
    0
    Views:
    38
    cPanelResources
    May 10, 2018
  3. Peter Horvath

    InnoDB crashed, no MySQL service available

    Peter Horvath, Apr 17, 2018, in forum: Database Discussion
    Replies:
    4
    Views:
    117
    cPanelMichael
    May 15, 2018
  4. Mayc

    Null Mysql Daemon Innodb Process

    Mayc, Feb 7, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    252
    cPanelMichael
    Feb 12, 2018
  5. z3d3m0n

    InnoDB database died

    z3d3m0n, Nov 18, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    283
    cPanelMichael
    Nov 20, 2017

Share This Page