So you want to mean that i can create (4TB/average_table_size) number of tables in a linux(2.6 kernel) operating system assuming i have that much hard disk space? On 12/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > 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 >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]