Practical samples for table types

[Nils Valentin]

Hello mysql fans ;-),

This time I have a question which sounds simple, but I believe the answer 
might not be so easy.

I would appreciate to hear from anybody some really good samples of which 
table type would be good for which occasion. 

I tried to look for some information perhaps a case study or something like 
this on the internet but I did not find anything like this. Either I looked 
for the wrong information or it doesnt exist yet.

I understand that ISAM tables are OS dependent and obsolete since MyISAM 
replaced them.

That still leaves 7 formats open.
(MyISAM, Merge Tables, HEAP, BDB, InnoDB, GEMINI)

I would appreciate a omparison chart or soemthing similar showing the features 
for each table type etc.

I want to figure out f.e. if  I can modify HEAP tables or perhaps even use 
them as slaves in a replication system.

What will happen when transformin Innodb tables into BDB or Gemini format. 
Would that be a good idea or not (and why) ?

While this is a complex topic I am approaching I dont expect a simple answer 
or anybody to know everything I am trying to get a more complete 
understanding  of the tables disadvantages and advantages. While the 
documentation lists up all options for each table I believe it doesn't 
necessary describe for which purpose they are useful.

Perhaps anybody around who was just thinking the same ?

-- 
================================================
Valentin Nils
Internet Technology

 E-Mail: nils@stripped
 URL: http://www.knowd.co.jp/staff/nils
------------------------------------------------
 有限会社ナレッジデザイン
 〒182-0024 東京都調布市布田4-6-1 調布丸善ビル7F
 Phone: [phone] Fax: [phone]
 URL: http://www.knowd.co.jp
================================================