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.

InnoDB

Discussion in 'General Discussion' started by Secret Agent, Dec 19, 2005.

  1. Secret Agent

    Secret Agent Guest

    Is there any cons of enabling InnoDB? If not, how do I enable this?

    My current /etc/my.cnf

    [mysqld]
    datadir=/var/lib/mysql
    skip-locking
    skip-innodb
    max_connections = 750
    key_buffer = 128M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1800
    thread_cache_size = 128
    wait_timeout = 1200
    connect_timeout = 10
    tmp_table_size = 128M
    read_rnd_buffer_size = 524288
    bulk_insert_buffer_size = 8M
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 2M
    query_cache_size = 128M
    query_cache_type = 1
    query_prealloc_size = 16384
    query_alloc_block_size = 16384
    old-passwords

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/lib/mysql/mysql.pid
    open_files_limit=8192

    [mysqldump]
    quick
    max_allowed_packet=16M
    default-character-set=binary

    [mysql]
    no-auto-rehash
    #safe-updates

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [mysqlhotcopy]
    interactive-timeout
     
  2. Stream

    Stream Well-Known Member

    Joined:
    Feb 7, 2004
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    To enable it just remove the line "skip-innodb" from your my.cnf and restart the mysql-server.
     

Share This Page