Windows

The only required parameter to use InnoDB is innodb_data_file_path, but you should set others if you want to get a better performance. 

Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB hard disk. Below is an example of possible configuration parameters in `my.cnf' for InnoDB: 

innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
innodb_data_home_dir = c:\ibdata
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:\iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:\iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

###
### EXAMPLE
###

#This File was made using the WinMySQLadmin 1.1 Tool
#30.04.2001 14:46:23

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/mysql
#bind-address=192.168.123.149
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
#--- ejb installation

# this is the home outside the mysql/data directory
innodb_data_home_dir = C:\mysql\ibdata

# name and size of data file:
innodb_data_file_path = ibdata1:200M;ibdata2:200M
set-variable = innodb_buffer_pool_size=20M
set-variable = innodb_additional_mem_pool_size=10M
innodb_log_group_home_dir = C:\mysql\iblogs
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = C:\mysql\iblogs
innodb_log_archive=0
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=10M
set-variable = innodb_log_buffer_size=10M
innodb_flush_log_at_trx_commit=0
set-variable = innodb_file_io_threads=12
set-variable = innodb_lock_wait_timeout=50
#---
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-max.exe
user=admin
password=adminpw