MySQL table partitioning advantages and classification analysis MySQL DBA learning

table Partitioning is the partitioning of a table's data according to a certain level of rulesintodifferent logical blocks, and physically stored separately, this rule is called partition function,can have different partition rules. through show Plugins statement to see if the current MySQL Support table partitioning feature. The table partitioning feature of the MySQL5.7 Community version is enabled by default. However, when a table contains a primary key or unique key, each field that is used as a partition function must be all or part of the unique key and primary key in the table, or you cannot create a partitioned table.  

the main advantages of table partitioning are:

1. can store more data in one table, break the disk limit or file system limit ;

2. It is easy to remove outdated or historical data from the table in the tables partition. As long as the corresponding partition is removed you can  

3. for some queries and modification statements, you can automatically narrow the data to one or several table partitions, optimize the execution efficiency of the statement , and execute the statement by displaying the specified table partition .

table partition types are:

1.rangeTable partition: Range table partition, according to a certain range of values to determine the data contained in each partition ;

2.listtable partition: Table partition, according to a certain value to determine the data contained in each partition ;

3.Hash Table partition: Hashtable partition, according to a custom function return value to determine the data contained in each partition ;

4.key table partition: Key table partition, similar to hash table partition, just use MySQL's own hash function to determine the data contained in each partition .

Most of the databases used by internet companies are MySQL , want to stand out from the many IT workers, need to have advanced technology, learning to add value is essential. The way of learning is your insistence. the old boy education MySQL DBA course, after several updates the course, put an end to the paper , the whole enterprise real case unifies the theory instruction, wants to study the MySQL dba 's knowledge deeply, Can pay attention to the old boy education.

MySQL table partitioning advantages and classification analysis MySQL DBA learning