# # Read the manual if you want to enable InnoDB! # See http://www.innodb.com/ # [mysqld] # Set default table type to INNODB. # This works for Mysql 4.0.x set-variable = default_table_type=innodb # OLAT innodb definitions in my.cnf innodb_data_file_path = ibdata/ibdata1:1000M;ibdata/ibdata2:1000M innodb_data_home_dir = /usr/local/opt/mysql-tablespace innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /usr/local/opt/mysql-log/mysql/iblogs innodb_log_files_in_group=3 innodb_log_file_size=50M innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = /usr/local/opt/mysql-log/mysql/iblogs innodb_log_archive=0 innodb_buffer_pool_size=300M innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=50