Multiple engines in one DB a problem?

[cnelson]

I'm trying to find a weird performance problem in a MySQL database.  I
use MySQL v5.0 but the db was migrated forward from a v4.1(?) system. 
Looking at the schema in a recent backup, I was surprised to find
different engines used for different tables:

  ...
  CREATE TABLE `comment` (
    `id` int(10) unsigned NOT NULL default '0',
    `entered` date default NULL,
    `author` varchar(20) default NULL,
    `about` mediumint(8) unsigned NOT NULL default '0',
    `comment` text,
    KEY `bySubject` (`about`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

  CREATE TABLE `country` (
    `abbrev` char(2) NOT NULL default '',
    `name` varchar(45) default NULL,
    PRIMARY KEY  (`abbrev`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  ...

Is this OK?  If not, what's the solution?  Backup, change all the
enginges to the same one, and restore?

                                             Chris


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]