We're considering switching to InnoDB tables for a couple of tables in our database where we need transactions. We're complete newbies with reference to innodb, although we are seasoned veterans with regards to MySQL/MyISAM and general concepts.
We have come up with a couple questions that we haven't been able to find answers on elsewhere. If the answers are available online somewhere, please let me know. 1) can you join a MyISAM table to an innodb table in a select? 2) Under 'Restrictions...' in the manual, it says: When you restart the MySQL server, InnoDB may reuse an old value for an AUTO_INCREMENT column. Under what circumstances does this occur? 3) Are there any replication issues? 4) Any issues regarding a mixed MyISAM/InnoDB environment that we should worry about? 5) Anyone who has done this in the past -- how much of a pain was it? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
