Hi,
I'mm having troubles getting InnoDb to work on mysql in windows. Here's what settings i have set up in winmysqladmin.
innodb_data_file_path = ibdata1:10M;ibdata2:10M
innodb_data_home_dir = e:\mysql\ibdata\
#set-variable = innodb_mirrored_log_groups=1
#innodb_log_group_home_dir = e:\mysql\iblogs
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=1M
#set-variable = innodb_log_buffer_size=1M
#innodb_flush_log_at_trx_commit=1
#innodb_log_arch_dir = e:\mysql\iblogs
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=4M
#set-variable = innodb_additional_mem_pool_size=4M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
Any Ideas on how I can get it working?
Oh and by the way has anyone managed to get postgresql working on windows with cygwin or by any other means? I'm sick of mysql and no subselects and having to go through all this crap just to get transactions. Can anyone recommend another db with subselects and transactions without all the other crap.
Thanks for your help,
Billy
I'mm having troubles getting InnoDb to work on mysql in windows. Here's what settings i have set up in winmysqladmin.
innodb_data_file_path = ibdata1:10M;ibdata2:10M
innodb_data_home_dir = e:\mysql\ibdata\
#set-variable = innodb_mirrored_log_groups=1
#innodb_log_group_home_dir = e:\mysql\iblogs
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=1M
#set-variable = innodb_log_buffer_size=1M
#innodb_flush_log_at_trx_commit=1
#innodb_log_arch_dir = e:\mysql\iblogs
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=4M
#set-variable = innodb_additional_mem_pool_size=4M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50
Any Ideas on how I can get it working?
Oh and by the way has anyone managed to get postgresql working on windows with cygwin or by any other means? I'm sick of mysql and no subselects and having to go through all this crap just to get transactions. Can anyone recommend another db with subselects and transactions without all the other crap.
Thanks for your help,
Billy