I *think* that the table size will be more important than the number of tables. Although as tables are actually stored as files on disk then it is probably not wise to have many many thousands piled up in the same directory.
I know of people with 50,000 plus files in one directory so I expect 10,000 tables (wihch I think will create 20000-30000 mysql files such as MYI and MYD) is realistic although I am totally guessing.
I know of people with 50,000 plus files in one directory so I expect 10,000 tables (wihch I think will create 20000-30000 mysql files such as MYI and MYD) is realistic although I am totally guessing.