:: How to enable InnoDB on MySQL from source
|
0 1 2 |
cd mysql ./configure --prefix=/usr/local/mysql --with-plugins=innobase,innodb_plugin make && make install |
:: Configure MySQL InnoDB on my.cnf
|
0 |
vi /etc/my.cnf |
add / configure like these:
|
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
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
|
0 1 |
mysqladmin -uroot -p shutdown mysqld_safe & |
:: Checking MySQL InnoDB
|
0 1 |
mysql -uroot -p mysql> show variables like "%engine%"; |
or
|
0 |
mysql> show engines; |
