Step 1) Switch from MyISAM to InnoDB (e.g. XtraDB) Step 2) /etc/mysql/my.cnf default_storage_engine    = InnoDB innodb_log_file_size = 128M innodb_buffer_pool_size = 8G…
Step 1) Switch from MyISAM to InnoDB (e.g. XtraDB) Step 2) /etc/mysql/my.cnf default_storage_engine    = InnoDB innodb_log_file_size = 128M innodb_buffer_pool_size = 8G…