Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [huey] How Many Tables Can A MySQL Database Handle

Quote Reply
Re: [huey] How Many Tables Can A MySQL Database Handle In reply to
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
Subject Author Views Date
Thread How Many Tables Can A MySQL Database Handle huey 2627 Jan 29, 2003, 8:04 AM
Post Re: [huey] How Many Tables Can A MySQL Database Handle
Paul 2537 Jan 29, 2003, 8:44 AM