MySQL系统数据库表可以转换为InnoDB吗? [英] Can the MySQL system database tables be converted to InnoDB?

问题描述

我最近安装了MySQL 5.5.我正在使用InnoDB作为所有数据库的引擎.我注意到mysql数据库的默认值及其所有表(用户，数据库等)都是MyISAM.他们是否有任何原因不能/不应为InnoDB?有人知道MySQL是否要求mysql db为MyISAM吗?

I've installed MySQL 5.5 recently. I'm using InnoDB as the engine for all my databases. I noticed that the mysql database default and all of it's tables (user, db, etc...) are MyISAM. Is there any reason they cannot / should not be InnoDB? Does anyone know if MySQL requires the mysql db to be MyISAM?

推荐答案

警告 不要将mysql数据库中的MySQL系统表从MyISAM转换为InnoDB表！这是不受支持的操作.如果这样做，在从备份还原旧系统表或使用mysql_install_db脚本重新生成旧系统表之前，MySQL不会重新启动.

Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables! This is an unsupported operation. If you do this, MySQL does not restart until you restore the old system tables from a backup or re-generate them with the mysql_install_db script.

http://dev.mysql.com/doc/refman/5.0/en /innodb-restrictions.html

这篇关于MySQL系统数据库表可以转换为InnoDB吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！