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.

Enable InnoDB?

Discussion in 'General Discussion' started by Rydel, Apr 6, 2007.

  1. Rydel

    Rydel Member

    Joined:
    Jul 31, 2004
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Is it possible to enable InnoDB on my VPS from the root version of WHM?
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    You can enable it by checking your my.cnf and comment out skip-innodb in /etc/my.cnf
     
  3. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
    I think there is more to it, such as setting the many variables. My question is about the variables shown in red below:

    Code:
    #skip-innodb
    innodb_buffer_pool_size=1G
    # Set the log file size to about 25% of the buffer pool size
    innodb_log_file_size=250M
    innodb_log_buffer_size=8M
    innodb_data_file_path=[COLOR="Red"]/idbdata1[/COLOR]:200M:autoextend
    innodb_additional_mem_pool_size=20M
    innodb_log_group_home_dir = [COLOR="Red"]/iblogs[/COLOR]
    innodb_log_files_in_group = 2
    innodb_flush_log_at_trx_commit=1
    innodb_lock_wait_timeout=10
    
    How can I set these file paths up? Have you done this?

    Thanks for any pointers!
     
  4. timdorr

    timdorr Well-Known Member
    PartnerNOC

    Joined:
    Jul 9, 2002
    Messages:
    93
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Atlanta, GA
    The extra variables are for tweaking. Unless you're going to make heavy use of InnoDB, the defaults are fine. Having just the skip-innodb line commented out or removed is sufficient to enable InnoDB.
     
Loading...

Share This Page