hi, When using MyISAM table, the limit will be determined by your operating system, ie. the number of files you can have in one directory.
Using InnoDB tables removes that limitation by allowing multiple tables within a single datafile (tablespace). The maximum tablespace size is 4 billion database pages. By default, a 'page' is 16K, but it is possible to recompile with 64K pages. This will allow a single tablespace size of ... 'BIG'. A table will obviously take up at least one database page, meaning you can theoretically have a maximum of 4 billion tables per tablespace. The number of tablespaces will again be limited by your operating system. Using NTFS on NT, the limit is 4,294,967,295. I imagine UNIX will be limited by the number of inodes. However, before reaching the physical limit of files you wil probably run into an issue with the maximum number of 'open' files allowed. --- Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > "kavitha kutty" <[EMAIL PROTECTED]> wrote: > > I am a student currently doing my final year MCA project.My project is in JSP > > and > > MySql.I have not studied MySql before.But I got more information about this > > database from > > MySql.com.But I have a doubt > > > >How many number of tables are possible in one MySql database? > > Maximum number of tables depends on your filesystem. But you should not put too many > tables in a > database, as opening tables will slow down. > ________________________________________________________________________ Yahoo! India Insurance Special: Be informed on the best policies, services, tools and more. Go to: http://in.insurance.yahoo.com/licspecial/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]