LNMP mysql启用innodb

LNMP安装是没有启用InnoDB的,可已进入MYSQL的安装目录,执行一下命令,重新编译MYSQL支持InnoDB。

./configure --prefix=/usr/local/mysql --with-extra-charsets=all --enable-thread-safe-client --enable-assembler --with-charset=utf8 --enable-thread-safe-client --with-extra-charsets=all --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=innobase

make && make install

重新编译

make;make install
/root/lnmp restart

mysql就启用InnoDB引擎了。