Enable InnoDB?

[Rydel]

Is it possible to enable InnoDB on my VPS from the root version of WHM?

 

[jayh38]

You can enable it by checking your my.cnf and comment out skip-innodb in /etc/my.cnf

 

[erick_paper]

I think there is more to it, such as setting the many variables. My question is about the variables shown in red below:

#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!

 

[timdorr]

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.