merge MyIsam??

[qasif]

Hi,
we need to try using MERGE MyISam tables on MySQL. Plz tell how safe/stable are they and what is the max size for MERGE tables? what is the disk size of MERGE tables? thankz! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

Its stability depends to the underlying MyISAM and the max size for MERGE tables is potentially no max size, probably limits by your available disk space
the disk size of MERGE tables is very small, it only needs to store the list of MyISAM tables name in the MERGE table in a text file, in addition of a .frm file. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --