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]
