limit on number of tables in mysql

[bonosa]

Is there a limit on the number of tables in a mysql database?

In the mysql cluster docs it says 1600, but is that something different from mysql? I am just interested in plain mysql.
thanks,
sb

 

[sleipnir214]

I don't recall there being a set limit.

For MyISAM tables, a database is a filesystem directory and a table in that database is a set of three filenames in that directory. Filesystems have limits on the number of entries that can be in a directory, so I suppose you could run in to that limit.

How many tables are we talking about?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bonosa]

technically unlimited. Each user is going to create 15 odd tables, and there can be any number of users. I am thinking perhaps I should give each user the ability to create his tables ina new database. Then there will be only 15 tables in each db. ANy limit on the numebr of databases in mysql?

THanks,
sb

 

[sleipnir214]

That would be, again, limited by the filesystem. At least with MyISAM tables.

The InnoDB storage engine uses a tablespace file for storage, similarly to the way Oracle and SQL Server store files. Perhaps that might be an option.


Want the best answers? Ask the best questions!

TANSTAAFL!!