Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL DB: Combo MyISAM and InnoDB is it doable, safe?

Status
Not open for further replies.

nemini

Programmer
Sep 22, 2008
21
US
I am in a situation where I need to implement InnoDB transaction capability.
But this will call for ALTER a few tables of a DB previously set exclusively with MyISAM table engine.

Is there any problem to foresee while operating a DB with a mixed table engine combo made of MyISAM & InnoDB?

 
From MySQL manual:

You can combine transaction-safe and non-transaction-safe tables in the same statements to get the best of both worlds. However, although MySQL supports several transaction-safe storage engines, for best results, you should not mix different storage engines within a transaction with autocommit disabled.

See:


Scott Prelewicz
Web Developer
COMAND Solutions
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top