Does anyone know how many tables the MySQL database can build? Solution Ideas

Does anyone know how many tables the MySQL database can build?
My company now to build support two-level domain name Japanese blog
I checked the Internet, only to find WordPress mu This system can meet the requirements, and I still use the Japanese language pack WordPress, can barely use
However, there is a problem now is the company to build hundreds of thousands of of the blog, and this system of database design is every creation of a blog will create a new 8 tables
That is to say, I want to build hundreds of thousands of blog, it is necessary to create millions of tables,
I think this is really a bit unworkable, so I would like to ask the cattle here, MySQL such a database there is no maximum number of tables AH?
What's the approximate amount?

------Solution--------------------
That's not a big bet.

Can you build multiple databases?
------Solution--------------------
I think this should be limited by the maximum number of file system files. A MyISAM table is 3 files, so your "millions of" has to take a 3.
------Solution--------------------
The database should not be broken, it should be a failed creation. I used to Google the maximum number of files that can be created under Linux, the root directory can be created under the limited (in a word), sub-directory is limited by the number of inode (this should be OK, but I did not further), now I have a directory of the number of files to 100,000, the site speed did not see the impact , but ll have some tea at the time of the catalogue. In fact, imagine that the directory itself is a database.
------Solution--------------------
It's not good to have such a big project with someone else's server.
------Solution--------------------
With space quotient space? And then build a project of this magnitude. This kind of .... Is your boss under consideration? What about the bandwidth problem? What about data backup? None of this is considered?
------Solution--------------------
There is no limit, which is mainly limited by your operating system and hardware.
------Solution--------------------
Explore
Reference:
With space quotient space? And then build a project of this magnitude. This kind of .... Is your boss under consideration? What about the bandwidth problem? What about data backup? None of this is considered?


Hey...
No way, who made me work for someone else?
Now this task has become a bit far-reaching, the data table a lot, create also slowed, but the boss is to reach this limit, I have to keep building, now fear is not know what to reach the upper limit when the performance is, the original I was each created 1000 will first back up the data, although this efficiency is too low, But I was afraid of the original created data to ruin, so I have to start again, but, looked at the 5 floor of the reply, I think you can not back up the

Hey, I always feel that the design is a little too flattering, who has no other design better PHP open source system recommended?

------Solution--------------------
It's best to rent one or one of them together.

