Does MySQL have a limit on the number of tables in a library?

On the internet to find a bit, there are almost no restrictions, but also said that the table is sure to affect the performance, combined should be said:

1) The number of tables in a library is limited, according to the UNSIGNED type, up to more than 4.2 billion, the normal application is not reached at all. 2) file system has a limit on the number of simultaneous open files, generally 2048. Although can be modified, but the design table structure, for those who may need to open the data table or do not split too thin, otherwise affect performance that is definitely drip. 3) The biggest disadvantage of splitting too much, reflected in: Database maintenance above. Therefore, we should carefully analyze their business model, data growth trends, technical strength and other comprehensive factors.