Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you about what the virtual host database 20m is. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

When many users buy a virtual host, the merchants will give away the database capacity, which is used to store the data files of the website and so on. The database of 20m indicates that the database space is 20m, which is not large.

For example, when a forum registers about 5000-30000 members, posts about 20000-50000 posts, and the forum data reaches 500 megabytes, its database is about 30-50 megabytes, and all pictures are about 100m.

The capacity of the website spatial database can be estimated, and the core analysis object is still the database table, as well as the view, index, log and other related ancillary information around the database table. After summarizing this information, coupled with the business growth of 3-5 years, the evaluation of database capacity can be given.

1. Database capacity of single table and single row

To analyze the single-row data capacity of a single table, it is necessary to analyze the bytes occupied by various databases and various data types, such as Oracle database: char type is as long as the number of bytes, Number type is calculated according to 22 bytes at most, the average calculation is based on 10 bytes, varchar type is calculated according to length 2amp 3, date type occupies 7 bytes.

According to the above assumption, if a customer table has 30 varchar (100), then a customer record is 2k, and 100000 customer information is nearly 200m, which increases by 30% per year, and the data space is increased by about 60m per year.

2. Database cache and memory capacity

The performance is better when the database cache (memory space) is 5% of the database space. First, the required database cache size is calculated according to the database capacity, and then the memory required by the operating system and system software is estimated, which is the total memory capacity required.

3. The machine system of the server can

In general, the CPU of the server machine reaches 70% can be better, beyond the excessive saturation, there are hidden dangers, below, the virtual space resources are not used reasonably. In addition, the analysis database space includes table log space, rollback space, redo space, temporary space and so on.

The above is what the virtual host database 20m shared by Xiaobian is. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.