mixing engine types
I have a medium-sized database, with a combination of static, mostly-static, and highly-variable data. It occurs to me that it would make most sense to put all of the 100% static data into MyISAM tables, duplicated on all of the data nodes. Although this would be a little annoying, there's a lot of it, and it feels like it would lighten the memory footprint significantly. Other than the admin headache, are there any caveats towards this kind of approach? For instance, might this cause problems when mixed (joined) with ndbcluster tables in select statements? Or is this what everyone does?
Subject
Views
Written By
Posted
mixing engine types
1598
September 02, 2006 12:25PM
982
September 05, 2006 12:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.