Can anyone please help, I'm trying to enable InnoDB by editing my.cnf:-
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = /ibdata/ibdata1:10M:autoextend
#innodb_data_home_dir =
innodb_log_group_home_dir = c:/phpdev/mysql/iblogs
innodb_log_arch_dir = c:/iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=20M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
These are meant to be the minimum settings (according to MySQL docs) Trouble is whenever I enable these as above MySQL won't start and the whole system slows dramatically and I have to close mysqld-max from task mangler!!!
Any clues?
![[noevil] [noevil] [noevil]](/data/assets/smilies/noevil.gif)
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = /ibdata/ibdata1:10M:autoextend
#innodb_data_home_dir =
innodb_log_group_home_dir = c:/phpdev/mysql/iblogs
innodb_log_arch_dir = c:/iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=20M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
These are meant to be the minimum settings (according to MySQL docs) Trouble is whenever I enable these as above MySQL won't start and the whole system slows dramatically and I have to close mysqld-max from task mangler!!!
Any clues?
![[noevil] [noevil] [noevil]](/data/assets/smilies/noevil.gif)