Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL3.23-Max on win98

Status
Not open for further replies.

squidster

Technical User
Oct 13, 2002
55
GB
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]
 
Its ok this was a 'feature' in 3.23.52, 4.0.3, 4.0.4 where InnoDB startup could take very long or even crash
on some Win 95/98/ME computers. Fixed in 3.23.53 and 4.0.5.

Hope this helps someone else!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top