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!

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:
    99
    Likes Received:
    6
    Trophy Points:
    8
    Location:
    kochin
    cPanel Access Level:
    Root Administrator
    #2 sktest123, May 14, 2018
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,214
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,214
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,214
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

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

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 cPanelMichael, May 16, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - InnoDB Support Enabled
  1. kernow

    SOLVED [CPANEL-22320] Table mysql/innodb_index_stats has length mismatch

    kernow, Nov 11, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    148
    kernow
    Nov 13, 2018 at 2:13 AM
  2. Luana Premoli

    Roundcube Error - Unknown storage engine InnoDB

    Luana Premoli, Aug 23, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    295
    cPanelMichael
    Aug 27, 2018
  3. cosmin

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    444
    cPanelMichael
    Jun 21, 2018
  4. cPanelMichael

    InnoDB fails to start on systems using MariaDB when the kernel is older than 2.6.24

    cPanelMichael, Jun 20, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    280
    Matthew Swift
    Nov 8, 2018
  5. brt

    Change InnoDB from Antelope to Barracuda?

    brt, May 20, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    1,169
    cPanelMichael
    May 21, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice