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!

Changing default-storage-engine

Discussion in 'Database Discussion' started by Telematica_at, Dec 2, 2017.

  1. Telematica_at

    Telematica_at Member

    Joined:
    Oct 6, 2015
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Austria
    cPanel Access Level:
    Root Administrator
    Hello,

    i have some questions to the default-storage-engine in cpanel 68 and mariaDB and i hope you can help me out of my questions.. :)

    First:
    As default mysql has InnoDB as default storage engine but vanilla cPanel installation put "default-storage-engine = MyISAM" into the my.conf file.

    Is there any background why cpanel recommends myISAM for mysql?


    Second:
    I read a lot on internet that InnoDB has more performance like myISAM for shared hosting enviroments, so i am thinking about to change the default-storage-engine value in the my.conf file from MYISAM to InnoDB.. is this safe to do, also if there are still many hundreds of hosting accounts on the cPanel server?


    Last:
    also if there is set "MyISAM" as default storage engine in my.conf i see that there are 2x more InnoDB tables on my cpanel Server like MyIAM talbes? Why that? i thought if "default storage engine" is set to "myISAM" then every new table will be myisam? If not, for what is this "default-storage-engine" else setting for?


    Thanks for your help.
     
    #1 Telematica_at, Dec 2, 2017
    Last edited: Dec 2, 2017
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    Repairing InnoDB tables is often a challenging process and thus it's not the default storage engine. You can search for "InnoDB" to get a better idea of issues users have faced.

    It's supported, but you may want to research to determine if that's the best choice for your server. MariaDB offers a useful document on this topic at:

    Choosing the Right Storage Engine

    The setting configures the default storage engine, but it doesn't prevent the use of InnoDB. Are you sure those tables were not created with InnoDB designated as the storage engine? See:

    MySQL :: MySQL 5.5 Reference Manual :: 15.1 Setting the Storage Engine

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Telematica_at

    Telematica_at Member

    Joined:
    Oct 6, 2015
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Austria
    cPanel Access Level:
    Root Administrator
    Hello again, and thank you for your answer:

    Thank you for your answer. i read this article and yah, also there the prefer for mariaDB the "innoDB" database over the MyISAM one... Also with MariaDB 10.2 it is the default engine there too...
     
Loading...

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.
    Dismiss Notice