sunaram patir <[EMAIL PROTECTED]> wrote on 12/11/2005 12:10:52 AM: > hi, > what is the maximum no of tables supported in a mysql database? >
That mostly depends on how large your hard drives are... Except for the InnoDB engine (in default mode) and the NDB engine, all other database engines use 1 or more files per table. How many individual files fit on your hard drive? Here is a page describing the maximum sizes of tables based on which operating system you are using: http://dev.mysql.com/doc/refman/4.1/en/table-size.html This article discusses the drawbacks to creating too many tables in the same database: http://dev.mysql.com/doc/refman/4.1/en/creating-many-tables.html This page starts the section about all database engines except InnoDB and NDB: http://dev.mysql.com/doc/refman/4.1/en/storage-engines.html This describes the InnoDB engine: http://dev.mysql.com/doc/refman/4.1/en/innodb.html This describes NDB Cluster: http://dev.mysql.com/doc/refman/4.1/en/ndbcluster.html Somewhere in those articles it may describe the theoretical limits to how many tables you can define but I can summarize them by saying that the actual limits will depend mostly on what type of operating system you have and how big your disks are. I have never heard of any one needing more tables than they could create. I would assume that a few thousand tables wouldn't be too many for most modern hard drives to handle. How many were you worried about? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
