What are the considerations needed when converting myisam to innodb.
I have a table around 80 GB with engine myisam. I would like to convert into innodb. What are the considerations needed to convert.
I'm using percona MySQL. I checked the table indexes and there is no full text searching indexes for the above table.
I plan to use percona online scheme change.
What are the considerations/pre-requisite to keep in mind to do this activity?
SHOW GLOBAL VARIABLES LIKE 'innodb_file_per_table';
4) How much RAM in the DB Server ? 5) How many CPU/cores ? 6) Is the DB Server bare metal or VM ?classic
(id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,classic_id
int(11) unsigned NOT NULL,classic_date
datetime NOT NULL,classic_name
varchar(100) DEFAULT NULL,classic_value
varchar(400) DEFAULT NULL, PRIMARY KEY (id
) ) ENGINE=MyISAM AUTO_INCREMENT=1236398635 DEFAULT CHARSET=utf8 1 row in set (0.00 sec) 3.innodb_file_per_table=ON 4.total mem=33gb, no swap 5. CPU(s) core=4 6.Its in amazon virtual.