100 million how data is divided into 100 tables in MySQL database (PHP), 100 MySQL
Below is a list of the next 100 million data by creating 100 tables, see the code below.
When the amount of data surges, we will choose the library table hash and so on to optimize the data read and write speed. The author made a simple attempt, 100 million data, divided into 100 sheets. The specific implementation process is as follows:
First create 100 tables:
Here's my table rule, full_code as the primary key, we hash the full_code.
The functions are as follows:
This gets the table name of the data stored by get_hash_table before inserting the data.
Finally, we use the merge storage engine to implement a complete code table
So we can get all the full_code data with SELECT * from code .
The above introduction is the whole content of this article, I hope to help you.
http://www.bkjia.com/PHPjc/1039184.html www.bkjia.com true http://www.bkjia.com/PHPjc/1039184.html techarticle 100 million How data is divided into 100 tables in MySQL database (PHP), 100 mysql below by creating 100 tables to demonstrate the next 100 million data of the sub-table process, see the following code. When data ...