Re: maximum number of tables supported in a mysql database
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]
Re: maximum number of tables supported in a mysql database
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
Re: maximum number of tables supported in a mysql database
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]
maximum number of tables supported in a mysql database
hi, what is the maximum no of tables supported in a mysql database? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: maximum number of tables supported in a mysql database
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
