MySQL: How many tables can one database hold?

[erikcw]

Hi all,

Can anyone tell my what the maximum number of tables a MySQL database can hold?

Thanks!

[jatar_k]

maybe this search will have an answer

[google.com...]

[jamie]

erik,

i have seen very popular and well-coded applications with 100 tables or more in a database. i've never even got near that size ;)

[Twisted Mind]

i think it depents on the disk space you have for your site ;) or restrictions on your webhost...

[arran]

I read there is no limit to the number of tables you can have in MySQL, however, as each table will need an id, a limit must exist. Saying that, before you reach that limit, the chances are you would have already run into OS issues (e.g. maximum number of files).

arran.

[Twisted Mind]

ull probally have ur hard disk full before ur at that point :)