maximum tables in database

[hanyaz]

hello,
i have installed wordpress multiblogging plateform on my dedicated server. I works well but i have a question about mysql load. Everytime a user is creating an account, a new set of tables are generated by the script to allow him/her to manage a blog.
So i was wondering how many tables can be created in a single databse. I am scrared to see mysql server crashing.
Thnaks in advance for any advice.
hanyaz

[rocknbil]

Although not a direct answer . . . From the documentation . . . [dev.mysql.com]

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL.

I believe the same is true of the number of tables. Each table is represented by a file, so in effect, you are asking the limitation of the number of files in a directory. It depends on your system's size, disk space, memory and how much is allocated to mySQL (if there are any limitations per program/resource.)

However, I did find an unconfirmed claim that may or may not be true:

The maximum tablespace size is 4 billion database pages.

[hanyaz]

thanks rocknbil,
4 billion database pages, it is huge...i ll see what's my disk capacity