The theory of MySQL partitioning technology

Source: Internet
Author: User
Tags hash range

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/

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.