MySql 分区

最新推荐文章于 2025-08-09 18:20:04 发布

原创最新推荐文章于 2025-08-09 18:20:04 发布 · 236 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

本文介绍了MySQL中的五种分区类型：RANGE、LIST、HASH、KEY和RANGE COLUMNS等，并展示了如何通过查询INFORMATION_SCHEMA.PLUGINS来查看当前可用的存储引擎。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

dev.mysql.com/doc/refman/5.6/en/partitioning-types.html

SELECT
        PLUGIN_NAME AS NAME,
        PLUGIN_VERSION AS VERSION,
        PLUGIN_STATUS AS STATUS
    FROM INFORMATION_SCHEMA.PLUGINS
    WHERE PLUGIN_TYPE='STORAGE ENGINE';

Name Version Status
binlog 1.0 ACTIVE
MEMORY 1.0 ACTIVE
MyISAM 1.0 ACTIVE
MRG_MYISAM 1.0 ACTIVE
CSV 1.0 ACTIVE
InnoDB 5.6 ACTIVE
FEDERATED 1.0 DISABLED
PERFORMANCE_SCHEMA 0.1 ACTIVE
ARCHIVE 3.0 ACTIVE
BLACKHOLE 1.0 ACTIVE
partition 1.0 ACTIVE

RANGE partitioning. This type of partitioning assigns rows to partitions based on column values falling within a given range. See Section 19.2.1, “RANGE Partitioning”. For information about an extension to this type, RANGE COLUMNS, see Section 19.2.3.1, “RANGE COLUMNS partitioning”.
LIST partitioning. Similar to partitioning by RANGE, except that the partition is selected based on columns matching one of a set of discrete values. See Section 19.2.2, “LIST Partitioning”. For information about an extension to this type, LIST COLUMNS, see Section 19.2.3.2, “LIST COLUMNS partitioning”.
HASH partitioning. With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. The function may consist of any expression valid in MySQL that yields a nonnegative integer value. An extension to this type, LINEAR HASH, is also available. See Section 19.2.4, “HASH Partitioning”.
KEY partitioning. This type of partitioning is similar to partitioning by HASH, except that only one or more columns to be evaluated are supplied, and the MySQL server provides its own hashing function. These columns can contain other than integer values, since the hashing function supplied by MySQL guarantees an integer result regardless of the column data type. An extension to this type, LINEAR KEY, is also available. See Section 19.2.5, “KEY Partitioning”.