mysql修改引擎_修改MySQL引擎

1. 显示MySQL支持的引擎：show engines;

mysql> show engines;

+--------------------+---------+------------------------------------------------

----------------+--------------+------+------------+

| Engine             | Support | Comment

| Transactions | XA   | Savepoints |

+--------------------+---------+------------------------------------------------

----------------+--------------+------+------------+

| FEDERATED          | NO      | Federated MySQL storage engine

| NULL         | NULL | NULL       |

| MRG_MYISAM         | YES     | Collection of identical MyISAM tables

| NO           | NO   | NO         |

| MyISAM             | YES     | MyISAM storage engine

| NO           | NO   | NO         |

| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to

it disappears) | NO           | NO   | NO         |

| CSV                | YES     | CSV storage engine

| NO           | NO   | NO         |

| MEMORY             | YES     | Hash based, stored in memory, useful for tempor

ary tables      | NO           | NO   | NO         |

| ARCHIVE            | YES     | Archive storage engine

| NO           | NO   | NO         |

| InnoDB             | DEFAULT | Supports transactions, row-level locking, and f

oreign keys     | YES          | YES  | YES        |

| PERFORMANCE_SCHEMA | YES     | Performance Schema

| NO           | NO   | NO         |

+--------------------+---------+------------------------------------------------

----------------+--------------+------+------------+

9 rows in set (0.00 sec)

2. 显示MySQL默认引擎：show variables like '%storage_engine%';

mysql> show variables like '%storage_engine%';

+----------------------------+--------+

| Variable_name              | Value  |

+----------------------------+--------+

| default_storage_engine     | InnoDB |

| default_tmp_storage_engine | InnoDB |

| storage_engine             | InnoDB |

+----------------------------+--------+

3 rows in set (0.11 sec)

3. 显示表引擎：show table status from ;

4. 修改引擎：

(1). my-default.ini文件中[mysqld]后添加default-storage-engine=InnoDB

(2). create table (...) engine=InnoDB;

(3). alter table engine=InnoDB;