Menu
I've been working on writing SQL to create a MySQL database with several default options, including character set and collation. Is it possible to set the default storage engine for tables in this database to InnoDB?
I've been looking through the MySQL 5.1 manual and I've found the statement ENGINE=innodb which would be appended to a CREATE TABLE statement, but I haven't found anything related to a CREATE DATABASE statement.
Is there a normal way to do this as part of the database creation, or does it need to be specified on a table-by-table basis?
553
InnoDB : The default storage engine in MySQL 8.0. InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data.
MySQL: InnoDB Storage Engine InnoDB is a storage engine for MySQL that balances high reliability and high performance. As of MySQL 5.5 and later, it is the default storage engine.
Access phpMyAdmin and select your database. Then click on SQL, place the following query and click on Go: ALTER TABLE my_table ENGINE = InnoDB; If the query is executed properly, the database engine of the table will be changed to InnoDB.
Quoting the Reference Manual (Setting the Storage Engine):
If you omit the
ENGINEoption, the default storage engine is used. Normally, this is MyISAM, but you can change it by using the--default-storage-engineserver startup option, or by setting thedefault-storage-engineoption in themy.cnfconfiguration file.
The default-storage-engine option must be part of the mysqld section in my.cnf;
[mysqld] default-storage-engine = innodb You may also want to change the default storage engine just for the current session. You can do this by setting the storage_engine variable:
SET storage_engine=INNODB; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
