Maximum Number of Tables

[sOlsTiCezA]

Hi

What is the maximum number of tables that can be created in a single MySQL Database ( ver 3.23.45 ) ?

 

[piti]

i think there is limitation on table size and not table count
only if there is some os restriction on how many files can a directory hold

 

[sOlsTiCezA]

I get up to +- 7500 tables and I then receive an error stating cannot create/write table. I can however manually
copy files into the database directory.

 

[piti]

well
maybe you could check the "tuning server parameters" section in the documentation, there are some advices how to change some settings when having many tables
hope that helps