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

This article mainly introduces how to add and delete MySQL5.5 partition, hoping to supplement and update some knowledge, if you have other questions to understand, you can continue to follow my updated article in the industry information.

1. Delete partition

# # View the amount of data of the partition to be processed and export it as a backup

Mysql > select count (*) from baby_account_change_log where updated_time > '2016-12-01 00mysql 00and updated_time select * into outfile' / tmp/baby_account_change_log_p1.sql' from baby_account_change_log where updated_time > '2016-12-01 0000 mysql 00' and updated_time explain partitions select count (*) and updated_time Alter table baby_account_change_log drop partition p0

Query OK, 0 rows affected (0.01 sec)

Second, increase the number of zones

# error prompt to delete storage maximum partition

Mysql > alter table baby_account_change_log add partition (PARTITION p13 VALUES LESS THAN (unix_timestamp ('2017-12-31 23 purl 59')

ERROR 1481 (HY000): MAXVALUE can only be used in last partition definition

# Delete storage maximum partition

Mysql > alter table baby_account_change_log drop partition p12

# # adding New Partition

Mysql > alter table baby_account_change_log add partition (PARTITION p12 VALUES LESS THAN (unix_timestamp ('2017-12-31 23 purl 59')

Read the above about how to add and delete MySQL5.5 partition processing, I hope it can give you some help in practical application. Due to the limited space in this article, it is inevitable that there will be deficiencies and need to be supplemented. If you need more professional answers, you can contact us on the official website for 24-hour pre-sales and after-sales to help you answer questions at any time.

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.