How to modify the data table engine of a mysql database

For MySQL databases, if you want to use transactions and row-level locks, you must use the INNODB engine. If you want to use full-text indexes, you must use myisam. INNODB is more practical, secure, and stable, but less efficient than MYISAM. However, some functions are not available in MYISAM. Modify MySQL engine to INNODB. You can use foreign keys, transactions, and other functions with high performance.

View the status of a data table

Copy codeThe Code is as follows:
Show table status from sites where name = 'SITE ';
Show table status from db_name where name = 'table _ name ';
 

Alter table Engine

Copy codeThe Code is as follows:
Alter table table_name engine = innodb;
Alter table table_name engine = myisam;