Beckham _ mysql partition instance and Beckham _ mysql instance

Beckham _ mysql partition instance and Beckham _ mysql instance
Mysql partition ExperimentBrief: 1. Create partitions Based on the partition type 2. Manage partitions 3. Examples of partitions and unpartitioned tables

 

1. Create a partition. Use hash partition as an example.

(1) Non-linear hash Partition

1. Test the t_hash structure of the table.

Create table t_hash (Id int unsigned, Name char (1) ) Engine = myisam charset = utf8 Partition by hash (id) Partitions 5;

2. t_hash table physical file structure

3. insert data to the t_hash table

4. view the physical structure of the t_hash table

Summary: hash partitions are evenly distributed. Therefore, the data file size of each partition is equal.

 

Ii. Manage partitions

1. hash partitions

2. Adjust the number of partitions 5 to 2.

3. Adjust the number of partitions 2 to 1.

Conclusion: Once hash partition is performed, at least one partition exists.

 

Iii. Examples of partitioned and unpartitioned tables

1. Test Table

Unpartitioned table: Create table t2 (Id int unsigned, Name char (1) ) Engine = myisam charset = utf8;

Partition Table: Create table t1 (Id int unsigned, Name char (1) ) Engine = myisam charset = utf8 Partition by hash (id) Partitions 4;

 

 

 

 

2. Insert data of the same number

3. Search for data with name

(Note: When no index is added, the partition takes less time than the unpartitioned one)

The quieter you become, the more you are able to hear!

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.