Asides

Enabling MySQL InnoDB Support in Windows

By xeroxss ⋅ February 11, 2009 ⋅  Email this post ⋅  Print this post ⋅ Post a comment

Just a quick note: InnoDB Engine for transactional support is by default not configured to run in MySQL Windows distribution. So if you want to use it you have to enable it manually by tweaking your mysql.ini configuration. Usually located in your mysql installation directory.

Look for this line : #Comment the following if you are using InnoDB tables
skip-innodb >>> change this line to this #skip-innodb and uncomment all that pertains to innodb. See the code below. Restart your MySQL and you are set to go.

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = “D:/xampp/mysql/”
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = “D:/xampp/mysql/”
innodb_log_arch_dir = “D:/xampp/mysql/”
## You can set .._buffer_pool_size up to 50 – 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

Tags: Enabling MySQL InnoDB in XAMPP for Windows, Enabling MySQL InnoDB support in Windows