MySQL: mixed table types - Eduardo Silva - com.mysql.lists.win32

2 messages in com.mysql.lists.win32MySQL: mixed table types

From	Sent On	Attachments
Eduardo Silva	09 Apr 2003 06:11
Eduardo Silva	10 Apr 2003 05:37

Subject:	MySQL: mixed table types
From:	Eduardo Silva (ecos...@hotmail.com)
Date:	04/09/2003 06:11:04 AM
List:	com.mysql.lists.win32

Hi.

I'm using MySQL 3.23.55 in a system with a little under 100 tables. As I mentioned in previous messages, one of the tables keeps getting crashed all the time. I'm considering using innoDB but I think MyIsam has some advantages, such as having distinct files for each table.

My question is:

could I use a mixed model, i.e., the tables that receive user's data (less than 8) would be innoDB while the other ones would be kept as MyISAM? This way I could easily send one or more of the auxiliary tables and the user would only copy them to the \mysql\data\xx directory. Has anyone tried it? Any reason why it would not be worth using?

TIA,

Eduardo