00Partitioning
suggest changeRemarks
- RANGE partitioning. This type of partitioning assigns rows to partitions based on column values falling within a given range.
- LIST partitioning. Similar to partitioning by RANGE, except that the partition is selected based on columns matching one of a set of discrete values.
- 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. - 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.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents
6 Insert
11 Delete
12 View
15 Comments
18 ALTER TABLE
19 Joins
20 UPDATE
22 JSON
23 MySQL Admin
24 TRIGGERS
28 SELECT
30 Group By
31 UNION
32 Drop Table
33 Data Types
35 Events
36 ENUM
38 Arithmetic
43 Log files
44 Partitioning
46 Backticks
47 mysqlimport
49 MySQL Unions
50 ORDER BY
51 MySQL client
54 Transaction
58 NULL
59 Replication
69 One to Many
73 Contributors