No, thanks! It's, in fact, more than enough! On 12/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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 > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
