Bug #14266 Merged Tables only hold 128
Submitted: 24 Oct 2005 16:44 Modified: 24 Oct 2005 19:27
Reporter: Nicollette Marquez Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:4.1 OS:Unix
Assigned to: CPU Architecture:Any

[24 Oct 2005 16:44] Nicollette Marquez 
Description:
I read a comment that stated only 128 tables are allowed with a merge table. Any more and you recieve an error. (http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html) 

Is this true? I am wanting to use the merge table functionality but do not want to waste my time if I won't be able to use it to it's fullest potential.

How to repeat:
I read a comment that stated only 128 tables are allowed with a merge table. Any more and you recieve an error. (http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html) 

Is this true? I am wanting to use the merge table functionality but do not want to waste my time if I won't be able to use it to it's fullest potential.
[24 Oct 2005 19:27] Hartmut Holzgraefe 
i have just tested with 150 tables on 4.1 and 5.0 and both are capable of handling that number of tables, i can't think of any limit either because the names of tables in a merge table are simply maintained in a plain text file with one file per table

what might happen though is that you run out of file handles when dealing with a merge table
with lots of sub-tables