Knowledgebase

InnoDB to MyISAM in CWP

Hello,

It’s very easy to change default storage engine from InnoDB to MyISAM in CWP.

Just follow below steps 

Login into the server via SSH
Open /etc/my.cnf file 

Add below line
default-storage-engine=MyISAM

Below is the example of modified file 

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
performance-schema=0
default-time-zone = ‘+05:30’