As I read the docs, yes! Is that going to be a limitation for you? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
sunaram patir <[EMAIL PROTECTED]> wrote on 12/11/2005 05:50:58 AM: > 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 > >