:: How to enable InnoDB on MySQL from source
cd mysql ./configure --prefix=/usr/local/mysql --with-plugins=innobase,innodb_plugin make && make install
:: Configure MySQL InnoDB on my.cnf
vi /etc/my.cnf
add / configure like these:
default-storage-engine = InnoDB # Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /usr/local/mysql/var innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/var # 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
:: Restarting MySQL
mysqladmin -uroot -p shutdown mysqld_safe &
:: Checking MySQL InnoDB
mysql -uroot -p mysql> show variables like "%engine%";
or
mysql> show engines;
