Davy, DO> I have been trying to get InnoDb to run on my windows XP machine. DO> (...) DO> #innodb_data_home_dir = DO> #innodb_log_group_home_dir = DO> #innodb_data_file_path = /ibdata/ibdata1:10M:autoextend
The remarks are in German, but I guess you will know what to do if you look at the following excerpt from my my.ini file on a Win2K machine: # InnoDB # Speicherort fuer Tablespaces (Vorgabe: DATADIR) innodb_data_home_dir=c:\mysql\innodb # Vorgabemaessig wird ab MySQL 4.0 # ein 64 MB grosser Tablespace namens ibdata1 # (per Vorgabe in DATADIR) angelegt. # Folgende Einstellungen ueberschreiben diesen Wert. innodb_data_file_path = ibdata1:100M;ibdata2:100M # Speicherort fuer Logdateien innodb_log_group_home_dir=c:\mysql\innodb innodb_log_arch_dir = c:\mysql\innodb # Logarchivierung anschalten (1) oder abschalten (0) innodb_log_archive=0 # Einstellungen fuer Logdateien # set-variable = innodb_mirrored_log_groups=1 # set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M # Puffer-Poolgroesse auf 50% bis 80% # des Arbeitsspeichers Ihres Computers setzen set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M # Transaktionen immer sicher (1) oder nicht (0) innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php