jayh38

Well-Known Member
Mar 3, 2006
1,212
0
166
You can enable it by checking your my.cnf and comment out skip-innodb in /etc/my.cnf
 

erick_paper

Well-Known Member
Apr 19, 2005
245
0
166
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!
 

timdorr

Well-Known Member
PartnerNOC
Jul 9, 2002
93
0
156
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.