Home : Products : DBMan SQL : Discussion :

Products: DBMan SQL: Discussion: Re: [huey] How Many Tables Can A MySQL Database Handle: Edit Log

Here is the list of edits for this post
Re: [huey] How Many Tables Can A MySQL Database Handle
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.

Last edited by:

Paul: Jan 29, 2003, 8:45 AM

Edit Log: