Re: Multiple table engine

On Sun, Apr 18, 2010 at 9:35 PM, Eric Bergen wrote: > This can become a problem when using replication. For example if you do: > > begin; > insert into innodb_table; > insert into myisam_table; > insert into innodb_table; > rollback; > > The innodb rows won't be replicated but the myisam row will

Re: Multiple table engine

This can become a problem when using replication. For example if you do: begin; insert into innodb_table; insert into myisam_table; insert into innodb_table; rollback; The innodb rows won't be replicated but the myisam row will. There is more info at: http://dev.mysql.com/doc/refman/5.0/en/innod

Re: Multiple table engine

Tompkins Neil wrote: Just looking for some confirmation that under a single database - I assume it is perfectly normal to have both MyISAM and InnoDB engines for different tables ? Is there anything I need to be aware of ? In most case no problems. MySQL can mix engines without problems. Every

回复: Multiple table engine

Different engines' tables have no connect each other. 2010-04-08 Best regards Timo Seven blog: http://zauc.wordpress.com #请翻墙浏览，或者指定hosts到74.200.243.252### UNIX System Admin & MySQL DBA 发件人: Tompkins Neil 发送时间: 2010-04-08 18:22 主 题: Multiple table engine 收件人: "[

Multiple table engine

Hi Just looking for some confirmation that under a single database - I assume it is perfectly normal to have both MyISAM and InnoDB engines for different tables ? Is there anything I need to be aware of ? Thanks Neil