To be a qualified program ape, in addition to the beauty of writing code, knowledge of the database is also indispensable. Here's a summary of how to view and change the MySQL database table storage Engine:
1, see the database can support the storage engine: show engines;
2. View the storage engine used by a table in a database: Show table status from Db_name where name= ' table_name '; (note: Remove the Where condition to see the storage engine of all tables in a database)
3, change the table engine method: ALTER tables TABLE_NAME ENGINE=INNODB;
4. Turn off the InnoDB engine method: Turn off the MySQL service via the "net stop MySQL" command, locate the My.ini file under the MySQL installation folder, and default-storage-engine= InnoDB changed to Default-storage-engine=myisam. Change the #skip-innodb to Skip-innodb, and finally start the MySQL service with the "net start MySQL" command.
View and change the MySQL database table storage Engine
