Get the App
SLTechnology News&Howtos  ›  Database  › 

An example of MySQL subpartition

Shulou Source: shulou.com Published: 2022-06-01 09:17:13 11月19日 Update

This is a real-world example, but I do not recommend using MySQL partitions for production

CREATE TABLE `tlog` (`ID`int (11) NOT NULL AUTO_INCREMENT COMMENT 'key ID', `VERSON` int (11) NOT NULL DEFAULT 0 COMMENT' version', `ACTIONS` varchar (100) DEFAULT NULL COMMENT 'operation record', `ADMINID` int (11) DEFAULT 1 COMMENT 'administrator ID', `IP`varchar (20) DEFAULT' 1' COMMENT 'login Ip', `CDATE`datetime NOT NULL COMMENT', `UDATE` datetime NOT NULL COMMENT 'modification time, PRIMARY KEY (`ID`, `CDATE`) KEY `ADMINID` (`ADMINID`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=' log table 'Time: 0.024sALTER TABLE `blog`.`t _ log` PARTITION BY RANGE (year (`CDATE`)) PARTITIONS 1SUBPARTITION BY HASH (to_days (`CDATE`)) SUBPARTITIONS 4 (PARTITION `p0` VALUES LESS THAN (2020) (SUBPARTITION `s200`, SUBPARTITION `s201`, SUBPARTITION `s202`, SUBPARTITION `s203`) Time: 0.057salter table t_logADD PARTITION (PARTITION `p1` VALUES LESS THAN (2021) (SUBPARTITION `s210` ENGINE=InnoDB, SUBPARTITION `s211` ENGINE=InnoDB, SUBPARTITION `s212` ENGINE=InnoDB) SUBPARTITION `s213` ENGINE = InnoDB) Time: 0.054s

Tags: Time example log version reality administrator this is recommendation production login management Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno OPPO Reno NVidia MySQL Shulou Tech Info Shulou Information