Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "what does mysql key partition refer to". The editor shows you the operation process through an actual case. The operation method is simple, fast and practical. I hope this article "what mysql key partition refers to" can help you solve the problem.

1. Partitioning by key is similar to partitioning by HASH, but the hash function of the key partition is provided by the MySQL server.

2. MySQLCluster uses the function MD5 () to implement the KEY partition, using only one list of one or more column names.

Example

Create table user (an int (11), b datetime) partition by key (b) partitions 4; that's all for "what does mysql key partition mean?" Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

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.