How to convert Mysql database from MyISAM to InnoDB
1. Shutdown mysql
/etc/init.d/mysqld stop
2. Change my.cnf file
cd /etc
cp my.cnf my_old.cnf
vi my.cnf
comment out skip-innodb
#skip-innodb
and add the following lines
default-storage-engine = innodb
innodb_buffer_pool_size = 200M
innodb_log_file_size = 100M
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 4M
innodb_additional_mem_pool_size = 20M
# num cpu’s/cores *2 is a good base line for innodb_thread_concurrency
innodb_thread_concurrency = 4
#commented out
#innodb_data_home_dir = /path/to/mysql
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /path/to/mysql
#transaction-isolation=READ-COMMITTED
3. Start Database
/etc/init.d/mysqld start
