mysql默认引擎变化_将mysql默认引擎更改为innodb

I am using mac and I installed mysql using homebrew.

brew install mysql

pretty standard installation.

mysql> show engines;

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

| Engine | Support | Comment | Transactions | XA | Savepoints |

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

| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |

| CSV | YES | CSV storage engine | NO | NO | NO |

| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |

| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |

| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |

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

I would like innodb to be the default storage engine. What do I need to do?

解决方案

Under [mysqld] section in your ini file, add:

default-storage-engine = innodb

It is usually /etc/my.cnf, but not sure about Mac.

From the docs:

On Unix, Linux and Mac OS X, MySQL programs read startup options from the following files, in the specified order (top items are used first).

File Name Purpose

/etc/my.cnf Global options

/etc/mysql/my.cnf Global options (as of MySQL 5.1.15)

SYSCONFDIR/my.cnf Global options

$MYSQL_HOME/my.cnf Server-specific options

defaults-extra-file The file specified with --defaults-extra-file=path, if any

~/.my.cnf User-specific options

The last one is never used by the daemon.