The theory of MySQL partitioning technology

First, the basic theory

In the MySQL large data processing, horizontal table technology is very common, but the table technology has brought a large number of PHP processing costs, in order to solve the drawbacks of Mysql5.1 later in a plug-in way to add a new technology-zoning technology.

Partitioning technology is a horizontal table at the logical level, a table for applications, and Mysql5.1 has 4 types of partitions

1. RANGE: Allocate multiple rows to partitions based on a column value belonging to a given continuous interval.

2, List: Similar to range partition, the difference is that the list partition is based on a column value matching a value in a discrete set of values to select

3. HASH: A partition that is selected based on the return value of a user-defined expression that uses the values of those columns that will be inserted into the table, which can contain any expressions that are valid in MySQL that produce nonnegative integer values.

4, key: Similar to hash, the difference is that the KEY partition only supports the calculation of one or more columns, and MySQL provides its own hash function.

Ii. comparison of different zoning techniques

This article comes from "phper-every day a little ~" blog, please be sure to keep this source http://janephp.blog.51cto.com/4439680/1305220

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/