How to disable the InnoDB engine in MySQL _ MySQL-mysql tutorial

How to disable the InnoDB engine in MySQL I. determine the version

View MySQL version
Mysql-V
You can also log on to MySQL using the select version (); or status; command to view

II. start work

Disable MySQL

Service mysql stop
If the preceding command cannot close MySQL, use the kill-9 command to forcibly kill the process;

Modify the MySQL configuration file my. cnf (usually located in/etc/mysql/my. cnf) and add the following fields

For MySQL 5.5:

Default-storage-engine = MyISAM
Loose-skip-innodb

Loose-innodb-trx = 0
Loose-innodb-locks = 0
Loose-innodb-lock-waits = 0
Loose-innodb-cmp = 0
Loose-innodb-cmp-per-index = 0
Loose-innodb-cmp-per-index-reset = 0
Loose-innodb-cmp-reset = 0
Loose-innodb-cmpmem = 0
Loose-innodb-cmpmem-reset = 0
Loose-innodb-buffer-page = 0
Loose-innodb-buffer-page-lru = 0
Loose-innodb-buffer-pool-stats = 0
For MySQL 5.6:

Default-storage-engine = MyISAM
Default-tmp-storage-engine = MYISAM
Loose-skip-innodb

Loose-innodb-trx = 0
Loose-innodb-locks = 0
Loose-innodb-lock-waits = 0
Loose-innodb-cmp = 0
Loose-innodb-cmp-per-index = 0
Loose-innodb-cmp-per-index-reset = 0
Loose-innodb-cmp-reset = 0
Loose-innodb-cmpmem = 0
Loose-innodb-cmpmem-reset = 0
Loose-innodb-buffer-page = 0
Loose-innodb-buffer-page-lru = 0
Loose-innodb-buffer-pool-stats = 0
Loose-innodb-metrics = 0
Loose-innodb-ft-default-stopword = 0
Loose-innodb-ft-inserted = 0
Loose-innodb-ft-deleted = 0
Loose-innodb-ft-being-deleted = 0
Loose-innodb-ft-config = 0
Loose-innodb-ft-index-cache = 0
Loose-innodb-ft-index-table = 0
Loose-innodb-sys-tables = 0
Loose-innodb-sys-tablestats = 0
Loose-innodb-sys-indexes = 0
Loose-innodb-sys-columns = 0
Loose-innodb-sys-fields = 0
Loose-innodb-sys-foreign = 0
Loose-innodb-sys-foreign-cols = 0

III. View Results

Log on to MySQL
Mysql-uroot-p your password
Display the database engine used

Show engines
+ -------------------- + --------- + ---------------------------------------------------------------- + ------------ +
| Engine | Support | Comment | Transactions | XA | Savepoints |
+ -------------------- + --------- + ---------------------------------------------------------------- + ------------ +
| FEDERATED | NO | Federated MySQL storage engine | NULL |
| CSV | YES | CSV storage engine | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO |
| BLACKHOLE | YES |/dev/null storage engine (anything you write to it disappears) | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO |
| InnoDB | NO | Supports transactions, row-level locking, and foreign keys | NULL |
| ARCHIVE | YES | Archive storage engine | NO |
| MyISAM | DEFAULT | MyISAM storage engine | NO |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO |
+ -------------------- + --------- + ---------------------------------------------------------------- + ------------ +
9 rows in set (0.00 sec)