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.

my.cnf and InnoDB

Discussion in 'General Discussion' started by drhonk, Jul 30, 2003.

  1. drhonk

    drhonk Active Member

    Joined:
    Aug 12, 2001
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Hi Guys,

    Any of you guys use InnoDB with your MySQL ? I tried to add InnoDB to my my.cnf but it kept on failing on restart. Can anybody share the my.cnf setting for InnoDB ?

    cPanel.net Support Ticket Number:
     
  2. drhonk

    drhonk Active Member

    Joined:
    Aug 12, 2001
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    anyone ?

    cPanel.net Support Ticket Number:
     
  3. perlchild

    perlchild Well-Known Member

    Joined:
    Sep 1, 2002
    Messages:
    279
    Likes Received:
    0
    Trophy Points:
    16
    My development box has innodb support with the defaults (just comment out skip-innodb and restart mysql)
    But since I'm not sure how it works out with quotas, and puts everything into one big file, plus each user has to create tables using an explicit innodb type, the advantages are not immediately visible. You gain the advantage of a table handler unsupported by mysql_check as well(apparently it doesn't need it... but I like the idea that I can fix problems... not call mysql for them)

    cPanel.net Support Ticket Number:
     

Share This Page