Does anyone know how many tables can be created in the mysql database? Solution

Source: Internet
Author: User
Does anyone know how many tables can be created in the mysql database? My company is now building a blog that supports second-level domain names in Japanese. I checked it online and found that the wordpressmu system can meet the requirements. In addition, I still use the Japanese language pack in wordpress, but I can barely use it, the problem is that the company wants to build hundreds of thousands of blogs, and the database design of this system is that every time a blog is created, eight new tables will be created. that is to say, if I want to create hundreds of thousands of blogs, I need to create hundreds. Does anyone know how many tables can be created in the mysql database?
My company wants to build a blog that supports second-level domain names in Japanese.
I checked it online. I only found that the wordpress mu system can meet the requirements, and I still use the Japanese language pack in wordpress.
However, the problem is that the company wants to build hundreds of thousands of blogs, and the database design of this system is that every time a blog is created, 8 new tables will be created.
That is to say, if I want to create hundreds of thousands of blogs, I need to create millions of tables,
I think this is a bit unfeasible, so I would like to ask if there is a maximum number of tables in a database such as mysql?
What is it?

------ Solution --------------------
So big, certainly not.

Can you create multiple databases?
------ Solution --------------------
I think this should be limited by the maximum number of files in the file system. A MyISAM table contains three files, so you have to multiply this "millions" by three.
------ Solution --------------------
The database should not be broken, but creation should fail. Previously, I used to google the maximum number of files that can be created in linux and the limited number of files that can be created in the root directory (as described by Alibaba Cloud ), the number of inode sub-directories is limited (this should be correct, but I have not checked it further). now the number of files in my Directory has reached 0.1 million, and the website speed has not been shown to be affected, but you can have some tea at the time of the Directory. As a matter of fact, the directory itself is also a database.
------ Solution --------------------
For such a large project, using other people's servers is always not very good.
------ Solution --------------------
Space provider space? Create a project that is so large. This is a bit .... Isn't your boss thinking too much? What about bandwidth? What about data backup? These are not considered?
------ Solution --------------------
There are no restrictions, mainly for your operating system and hardware.
------ Solution --------------------
Discussion
Reference:
Space provider space? Create a project that is so large. This is a bit .... Isn't your boss thinking too much? What about bandwidth? What about data backup? These are not considered?


Ah...
No way. who asked me to work for someone else?
Now this task is a little far from being created, and the creation of more data tables slows down. but the boss just wants to reach this limit and I have to keep building it, I am afraid that I don't know what the performance is when I reach the upper limit. it turns out that every time I create one thousand, I have to back up the data first. Although this is too inefficient, however, I am afraid to break down the data I created, so I have to start over again. However, after reading the reply from the fifth floor, I think I don't need to back up the data first.

Ah, I always think this design is a bit flattering. Who else should I recommend a better PHP open-source system?

------ Solution --------------------
It is best to share a rent or a share with others

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.