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

This article will explain in detail how to achieve hash partition in mysql. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

1. Hash partitions are mainly used to ensure that data is evenly distributed among a predetermined number of partitions.

2. The closer the expression value changes to the value of the column on which it is based, the more effectively MySQL can use the expression for HASH partitioning.

Example

CREATE TABLE employees (id INT NOT NULL, fname VARCHAR (30), lname VARCHAR (30), hired DATE NOT NULL DEFAULT '1970-01-01-01, separated DATE NOT NULL DEFAULT' 9999-12-31, job_code INT, store_id INT) PARTITION BY HASH (store_id) PARTITIONS 4 This is the end of this article on "how to achieve hash partitioning in mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.