How to deal with mysql sub-tables? When there is a large amount of data, how can we store 2 million of the data in a table based on the data volume? how can we use mysql to perform table sharding queries? ------ Solution ------------------ what is the size of the php central control tabulation? We recommend that you flip the mysql Partition. about 5.1 + support the range, hash, and so on ...... Partition method. what can I do with mysql table sharding?
When there is a large amount of data, how can we store 2 million of the data in a table based on the data volume? how can we use mysql to perform table sharding queries?
------ Solution --------------------
What is the size of the central control tabulation in php?
We recommend that you refer to mysql Partition, which is about 5.1 + supported.
Set appropriate fields according to range, hash ...... Partitioning method. I want to achieve the same requirement.
The advantage is that in data operations, you do not need to manually determine which tables the data is queried from,