Is it possible, desirable, etc. to convert the mysql grant, system, etc. tables to innodb? I.e.,
use mysql; alter table columns_priv type = innodb; alter table db type = innodb; alter table func type = innodb; alter table host type = innodb; alter table tables_priv type = innodb; alter table user type = innodb; quit;
Not a good idea:
The MyISAM storage engine is always present. InnoDB is not. You'll no longer have the option of running a server without InnoDB compiled in, and you'll no longer have the option of starting the server with --skip-innodb.
Also mysql_fix_privilege_tables will change the tables to MyISAM even if you change them to InnoDB.
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
