MySQL表分MySQL表分區(qū) | | | |Library|License | | |STORAGE | | | | |STORAGE | | | |DISABLED|STORAGEENGINE| | | | |STORAGE | | | | | | | MySQL表分區(qū)mysql>CREATETABLEemployees(idINTNOTjob_codeINTNOTstore_idINTNOTNULL(PARTITIONp0VALUESLESSTHAN(6),PARTITIONp1VALUESLESSTHANPARTITIONp2VALUESLESSTHAN(16),PARTITIONp3VALUESLESSTHAN(21)mysql>insertintoemployeesmysql>select*from |id|fname|lname| |separated|job_code|store_id |1| | |2017-06-07|2017-06-07 1 1|2| | |2017-06-07|2017-06-07 1 6mysql>select*fromemployeespartition |id|fname|lname| |separated|job_code|store_id |1| | |2017-05-31|2017-05-31 1 1mysql>select*fromemployeespartition |id|fname|lname| |separated|job_code|store_id |2| | |2017-06-07|2017-06-07 1 6mysql>CREATETABLEtnpidINTNOTNULLrefBIGINTNOTnamePRIMARYKEYpkUNIQUEKEYuk(ref)PARTITIONBYRANGE(PARTITIONp0VALUESLESSTHAN(6),PARTITIONp1VALUESLESSTHANERROR1503(HY000):AUNIQUEINDEXmustincludeallcolumnsinthetable'spartitioningmysql>CREATETABLEtnp(idINTNOTrefBIGINTNOTnamePRIMARYKEYpkUNIQUEKEYuk(ref)PARTITIONBYRANGE(PARTITIONp0VALUESLESSTHAN(6),PARTITIONp1VALUESLESSTHANERROR1503(HY000):APRIMARYKEYmustincludeallcolumnsinthetable'spartitioningmysql>CREATETABLEtnpidINTNOTNULLrefBIGINTNOTnamePRIMARYKEYpkPARTITIONBYRANGE(PARTITIONp0VALUESLESSTHAN(6),PARTITIONp1VALUESLESSTHANQueryOK,0rowsaffected(0.03或者將主鍵擴(kuò)展為包含refmysql>CREATETABLEtnp(idINTNOTNULLrefBIGINTNOTnamePRIMARYKEYpkUNIQUEKEYuk(ref)PARTITIONBYRANGE(PARTITIONp0VALUESLESSTHAN(6),PARTITIONp1VALUESLESSTHANQueryOK,0rowsaffected(0.03可以允許在一個(gè)表 行效率。而且可以通過(guò)顯示指定表分區(qū)來(lái)執(zhí)行語(yǔ)句，比如SELECT*FROMtPARTITION(p0,p1)WHEREc<5[root@vmware1data]#cd

MySQL表分區(qū)LIST表分區(qū)：列表表分區(qū)，按照一個(gè)一個(gè)確定的值來(lái)確定每個(gè)分區(qū)包含的數(shù)HASH表分區(qū)：哈希表分區(qū)，按照一個(gè)自定義的函數(shù)返回值來(lái)確定每個(gè)分區(qū)包含的數(shù)KEY表分區(qū)：key表分區(qū)，與哈希表分區(qū)類似，只是用MySQL自己的HASH函數(shù)來(lái)確定每MySQL表分區(qū) 部分，通過(guò)使用VALUESLESSTHAN來(lái)定CREATETABLEemployees(idINTNOTfnameVARCHAR(30),lnamehiredDATENOTNULLDEFAULT'1970-01-separatedDATENOTNULLDEFAULT'9999-12-job_codeINTNOTstore_idINTNOTNULLPARTITIONBYRANGE(PARTITIONp0VALUESLESSTHAN(6),PARTITIONp1VALUESLESSTHANPARTITIONp2VALUESLESSTHAN(16),PARTITIONp3VALUESLESSTHAN(21)當(dāng)新插入的數(shù)據(jù)為(72,‘Mitc ’,‘Wilson’,‘1998-06-25’,NULL,13)時(shí)，則新數(shù)據(jù) mysql>insertintoemployeesERROR1526(HY000):Tablehasnopartitionforvaluemysql>CREATETABLEemployees(idINTNOTjob_codeINTNOTstore_idINTNOTNULL(PARTITIONp0VALUESLESSTHAN(6),PARTITIONp1VALUESLESSTHANPARTITIONp2VALUESLESSTHAN(11),PARTITIONp3VALUESLESSTHAN(21)ERROR1493(HY000):VALUESLESSTHANvaluemustbestrictlyincreasingforeachjob_codeINTNOTstore_idINTNOTNULL(PARTITIONp0VALUESLESSTHAN('a'),PARTITIONp1VALUESLESSTHANPARTITIONp2VALUESLESSTHAN('c'),PARTITIONp3VALUESLESSTHAN('d')ERROR1697(HY000):VALUESvalueforpartition'p0'musthavetypeMySQL表分區(qū)hiredDATENOTNULLDEFAULT'1970-01-01',separatedDATENOTNULLDEFAULT'9999-12-job_codeINTNOTNULL,store_idINTNOTNULLPARTITIONBYRANGE(PARTITIONp0VALUESLESSTHANPARTITIONp1VALUESLESSTHANPARTITIONp2VALUESLESSTHAN 的作用是表示可能的最大值，所以任何store_id>=16的數(shù)據(jù)都會(huì)被寫入到p3分區(qū)分區(qū)函數(shù)中也可以使用表達(dá)式hiredDATENOTNULLDEFAULT'1970-01-01',separatedDATENOTNULLDEFAULT'9999-12-job_codeINT,store_idINT(PARTITIONp0VALUESLESSTHANPARTITIONp1VALUESLESSTHANPARTITIONp2VALUESLESSTHANMySQL表分區(qū)對(duì)timestamp字段類型可以使用的表達(dá)式目前僅有unix_timestamp，其他的表達(dá)式都不允CREATETABLEquarterly_report_status(report_idINTNOTNULL,report_statusVARCHAR(20)NULL,report_updatedTIMESTAMPNOTNULLDEFAULTCURRENT_TIMESTAMPONCURRENT_TIMESTAMPmysql>createtabletemp(tstamptimestamp)partitionbyrange(year(tstamp))(partitionp0valuesERROR1486(HY000):Constant,randomortimezone-dependentexpressionsin(sub)partitioningfunctionarenotallowedQueryOK,0rowsaffected(0.01MySQL表分區(qū)LIST表分區(qū)：列表表分區(qū)，按照一個(gè)一個(gè)確定的值來(lái)確定每個(gè)分區(qū)包含的數(shù)通過(guò)PARTITIONBYLIST(expr)分區(qū)函數(shù)表達(dá)式必須返回整數(shù)，取值范圍通過(guò)VALUESIN(value_list)定hiredDATENOTNULLDEFAULT'1970-01-separatedDATENOTNULLDEFAULT'9999-12-PARTITIONBYPARTITIONpEastVALUESINPARTITIONpWestVALUESINPARTITIONpCentralVALUESIN(7,8,15,16)hiredDATENOTNULLDEFAULT'1970-01-separatedDATENOTNULLDEFAULT'9999-12-job_codeINT,store_namevarchar(20)PARTITIONBYPARTITIONpEastVALUESINERROR1697(HY000):VALUESvalueforpartition'pNorth'musthavetypeMySQL表分區(qū)對(duì)List表分區(qū)來(lái)說(shuō)，沒(méi)有MAXVALUE特殊值，所有的可能取值都需要再VALUESIN中包含，如果有定義的取值則PARTITIONBY(PARTITIONp0VALUESIN(1,4,PARTITIONp1VALUESIN(2,5,QueryOK,0rowsaffected(0.11mysql>INSERTINTOh2VALUES(3,ERROR1525(HY000):Tablehasnopartitionforvalue同樣，當(dāng)有主鍵或者唯一鍵存在的情況下，分區(qū)函數(shù)字段需要包含在主鍵或唯一鍵hiredDATENOTNULLDEFAULT'1970-01-separatedDATENOTNULLDEFAULT'9999-12-PARTITIONBYPARTITIONpEastVALUESINERROR1503(HY000):APRIMARYKEYmustincludeallcolumnsinthetable'spartitioningMySQL表分區(qū)分區(qū)多字段函數(shù)(columnpartition)DATEandMySQL表分區(qū)每個(gè)column_list里的字段和value_list里的數(shù)值必須一一對(duì)應(yīng)，數(shù)據(jù)類型也要一的值列表的第一個(gè)元素是 MySQL表分區(qū)cCHAR(3),dQueryOK,0rowsaffected(0.15mysql>insertintorcxvalues(4,5,'abc',1),(5,9,'abc',1),(4,11,'ggg',1),(5,11,'abc',1),(6,2,mysql>select*fromrcxpartition | | | | |45|abc 1|59|abc 1|411|ggg 1?mysql>select*fromrcxpartition? ?| | | | ? ? 5 11|abc 1? 6 2|abc 1MySQL表分區(qū)CREATETABLErc1(aINT,bINTPARTITIONBYRANGECOLUMNS(a,(PARTITIONp0VALUESLESSTHAN(5,PARTITIONp3VALUESLESSTHAN(MAXVALUE,MAXVALUE)mysql>INSERTINTOrc1VALUES(5,10),(5,11),mysql>SELECT ||

| |

|2 |1mysql>SELECT(5,10)<(5,12),(5,11)<(5,12),(5,12)< |(5,10)<(5,12)|(5,11)<(5,12)|(5,12)< |1|1|0 MySQL表分區(qū)CREATETABLErc4(aINT,bINT,cINT(PARTITIONp0VALUESLESSTHANmysql>CREATETABLErcf(aINT,bINT,cPARTITIONBYRANGECOLUMNS(a,b,c)PARTITIONp0VALUESLESSTHANERROR1493(HY000):VALUESLESSTHANvaluemustbestrictlyincreasingforeachMySQL表分區(qū)CREATETABLEemployees_by_lname(idINTNOTNULL,fnamejob_codeINTNOTNULL,store_idINTNOTNULL(PARTITIONp0VALUESLESSTHANCREATETABLEemployees_by_lname(idINTNOTNULL,fnamejob_codeINTNOTNULL,store_idINTNOTNULLMySQL表分區(qū)list列表多字段表分CREATETABLEstreet_1VARCHAR(30),street_2(PARTITIONpRegion_1VALUESIN('Oskarshamn','H?gsby',MySQL表分區(qū)通過(guò)PARTITIONBYHASHexpr)子句來(lái)表達(dá)哈希表分區(qū)，其中的exprCREATETABLEemployees(idINTNOTNULL,fnamejob_codeINT,store_idINTPARTITIONBYPARTITIONS如果沒(méi)有寫明PARTITIONS字段，則默認(rèn)為CREATETABLEemployees(idINTNOTNULL,fnamelnameVARCHAR(30),hiredDATENOTNULLDEFAULT'1970-01-PARTITIONSmysql>insertintoemployeesmysql>insertintoemployeesmysql>insertintoemployeesmysql>insertintoemployeesmysql>insertintoemployeesmysql>select*fromemployees |id|fname|lname| |separated|job_code|store_id |1| | |2017-05-31|2017-05-31 1 4 mysql>select*fromemployees |id|fname|lname| |separated|job_code|store_id |1| | |2017-05-31|2017-05-31|1| | |2017-05-31|2017-05-31

1 11 5 +—— mysql>select*fromemployees |id|fname|lname| |separated|job_code|store_id |1| | |2017-05-31|2017-05-31 1 2mysql>select*fromemployees |id|fname|lname| |separated|job_code|store_id |1| | |2017-05-31|2017-05-31 1 3MySQL表分區(qū)比如CREATETABLEt1(col1INT,col2CHAR(5),col3PARTITIONBYHASH(YEAR(col3)PARTITIONS如果插入一條數(shù)據(jù)對(duì)應(yīng)的col3為‘2005-09-15’時(shí)，則插入數(shù)據(jù)的分區(qū)計(jì)算方法MOD(YEAR('2005-09- = =MySQL表分區(qū)CREATETABLE...PARTITIONBYKEY()創(chuàng)建key表分區(qū)，括號(hào)里面可以包含0個(gè)或者多個(gè)字段，所的字段必須是主鍵或者主鍵的一部分，如果括號(hào)里面沒(méi)有字段，則代表使用主CREATETABLEk1(idINTNOTNULLPRIMARYKEY,nameVARCHAR(20)PARTITIONBYPARTITIONS如果表中沒(méi)有主鍵但有唯一鍵，則使用唯一鍵，但唯一鍵字段必須定義為notnullmysql>CREATETABLEk1(idINT,nameVARCHAR(20),UNIQUEKEY(id))BYKEY()PARTITIONSERROR1488(HY000):FieldinlistoffieldsforpartitionfunctionnotfoundinCREATETABLEk1(idINTNOTNULL,nameVARCHAR(20),UNIQUEKEY(id))PARTITIONBYKEY()PARTITIONS CREATETABLEtm1(s1CHAR(32)PRIMARYKEYPARTITIONBYMySQL子表分CREATETABLEts(idINT,purchasedPARTITIONBYRANGE(YEAR(purchased)SUBPARTITIONBYHASH(TO_DAYS(purchased)(PARTITIONp0VALUESLESSTHANPARTITIONp1VALUESLESSTHANPARTITIONp2VALUESLESSTHANMAXVALUECREATETABLEts(idINT,purchasedPARTITIONBYRANGE(YEAR(purchased)SUBPARTITIONBYHASH(TO_DAYS(purchased)(PARTITIONp0VALUESLESSTHAN(SUBPARTITIONs0,SUBPARTITIONs1PARTITIONp1VALUESLESSTHAN(SUBPARTITIONs2,SUBPARTITIONs3PARTITIONp2VALUESLESSTHAN(SUBPARTITIONs4,SUBPARTITIONs5)MySQL表分區(qū)對(duì)Nullmysql>CREATETABLEt1(c1 c2VARCHAR(20)PARTITIONBY(PARTITIONp0VALUESLESSTHANPARTITIONp1VALUESLESSTHANPARTITIONp2VALUESLESSTHANMAXVALUEmysql>INSERTINTOt1VALUES(NULL,QueryOK,1rowaffected(0.00mysql>select*fromt1 | | |NULL|mothraMySQL表分區(qū)對(duì)Null(PARTITIONp0VALUESIN(0,3,PARTITIONp1VALUESIN(1,4,PARTITIONp2VALUESIN(2,5,QueryOK,0rowsaffected(0.01mysql>INSERTINTOts1VALUES(9,ERROR1504(HY000):Tablehasnopartitionforvaluemysql>INSERTINTOts1VALUES(NULL,ERROR1504(HY000):Tablehasnopartitionforvalue(PARTITIONp0VALUESIN(0,3,PARTITIONp1VALUESIN(1,4,PARTITIONp2VALUESIN(2,5,QueryOK,0rowsaffected(0.01(PARTITIONp0VALUESIN(0,3,PARTITIONp1VALUESIN(1,4,7,PARTITIONp2VALUESIN(2,5,QueryOK,0rowsaffected(0.01MySQL表分區(qū)對(duì)Nullmysql>INSERTINTOts2VALUES(NULL,QueryOK,1rowaffected(0.00mysql>INSERTINTOts3VALUES(NULL,QueryOK,1rowaffected(0.00對(duì)哈希表分區(qū)和Key表分區(qū)來(lái)說(shuō)，NULL值會(huì)被當(dāng)成0值對(duì)PARTITIONBYPARTITIONSQueryOK,0rowsaffected(0.00mysql>INSERTINTOthVALUES(NULL,'mothra'),(0,QueryOK,1rowaffected(0.00mysql>select*fromth | | |NULL|mothra 0|gigan 2rowsinset(0.01MySQL表分區(qū)PARTITIONBYRANGE(YEAR(purchased)(PARTITIONp0VALUESLESSTHAN(1990),PARTITIONp1VALUESLESSTHAN(1995),PARTITIONp2VALUESLESSTHAN(2000),PARTITIONp3VALUESLESSTHAN(2005),PARTITIONp4VALUESLESSTHAN(2010),PARTITIONp5VALUESLESSTHAN(2015));QueryOK,0rowsaffected(0.28insertintotrvalues(1,'abc','1999-12-mysql>select*fromtr | |name|purchased 1|abc|1999-12-21QueryOK,0rowsaffected(0.03mysql>showcreatetable(PARTITIONp0VALUESLESSTHAN(1990)ENGINE=PARTITIONp1VALUESLESSTHAN(1995)ENGINE=PARTITIONp5VALUESLESSTHAN(2015)ENGINE=InnoDB)*/mysql>SELECT*FROMtrWHEREpurchasedBETWEEN'1995-01-01'AND'1999-12-Emptyset(0.00MySQL表分區(qū)在原分區(qū)上增加一個(gè)表分區(qū)可以通過(guò)altertableaddpartitionDATE)PARTITIONBYRANGE(YEAR(dob)(PARTITIONp0VALUESLESSTHANmysql>insertintomembersvalues(1,'a','b','1978-01-QueryOK,1rowaffected(0.01 ERROR1463(HY000):VALUESLESSTHANvaluemustbestrictlyincreasingforALTERTABLEmembersREORGANIZEPARTITIONp0(PARTITIONn0VALUESLESSTHAN(1970),PARTITIONn1VALUESLESSTHAN(1980));mysql>showcreatetable|members|CREATETABLE`members``fname`varchar(25)DEFAULT`lname`varchar(25)DEFAULT`dob`dateDEFAULT)ENGINE=InnoDBDEFAULT/*!50100PARTITIONBYRANGE((PARTITIONn0VALUESLESSTHAN(1970)ENGINE=PARTITIONn1VALUESLESSTHAN(1980)ENGINE=PARTITIONp1VALUESLESSTHAN(1990)ENGINE=PARTITIONp2VALUESLESSTHAN(2000)ENGINE=PARTITIONp3VALUESLESSTHAN(2010)ENGINE=InnoDB)*/mysql>select*from | |fname|lname| 1| | |1978-01-01 mysql>select*frommembers | |fname|lname| 1| | |1978-01-01 MySQL表分區(qū)對(duì)列表表分區(qū)來(lái)說(shuō)，只要新增加的分區(qū)對(duì)應(yīng)的值在之前的表分區(qū)中沒(méi)有出現(xiàn)過(guò)，就可以通過(guò)altertable…add(PARTITIONp0VALUESIN(5,10,PARTITIONp1VALUESIN(6,12,18)ALTERTABLEttADDPARTITION(PARTITIONp2VALUESIN(7,14,當(dāng)然，也可以通過(guò)REORGANIZE命令將之前的多個(gè)分區(qū)合并成一個(gè)或幾個(gè)分區(qū)，但要保持分區(qū)值一致THAN(1970));ERROR1520(HY000):ReorganizeofrangepartitionscannotchangetotalrangesexceptforlastpartitionwhereitcanextendtherangeTHAN(1985));ERROR1520(HY000):ReorganizeofrangepartitionscannotchangetotalrangesexceptforlastwhereitcanextendtheTHAN(1980));QueryOK,0rowsaffected(0.04Records:0Duplicates:0Warnings:更復(fù)雜的比如將多個(gè)ALTERTABLEmembersREORGANIZEPARTITIONp0,p1,p2,p3INTO(PARTITIONm0VALUESTHAN(1980),PARTITIONm1VALUESLESSTHANmysql>ALTERTABLEmembersREORGANIZEPARTITIONp0,p1,p2,p3INTO(PARTITIONm0LESSTHAN(1980),PARTITIONm1VALUESLESSTHAN(PARTITIONp1VALUESIN(6,18),PARTITIONnpVALUESin(4,8,12));ERROR1519(HY000):Whenreorganizingasetofpartitionstheymustbeinconsecutivemysql>showcreatetable +|Table|Create+| /*!50100PARTITIONBYLIST(PARTITIONp0VALUESIN(5,10,15)ENGINE=PARTITIONp1VALUESIN(6,12,18)ENGINE=PARTITIONp2VALUESIN(7,14,21)ENGINE=PARTITIONnpVALUESIN(4,8)ENGINE=InnoDB)*/mysql>insertintottmysql>ALTERTABLEttREORGANIZEPARTITIONp0,p1INTO(PARTITIONp0VALUESIN(6,18),PARTITIONQueryOK,0rowsaffected(0.07Records:0Duplicates:0Warnings:mysql>select*from | |data +------ 2 5 1rowinset(0.01MySQL表分區(qū) 與范圍和列表表分區(qū)完全不同，比如不能刪除表分區(qū)，但可以通過(guò)ALTERTABLE... mysql>insert QueryOK,0rowsaffected(0.02 yze | | |Msg_type|Msg_text | s yze| | 1rowinset(0.02 |partition_name|table_rows ++||0||1||1||1||1||0||||00

yze | | |Msg_type|Msg_text | s yze| | 1rowinset(0.05mysql>selectpartition_name,table_rowsfrominformation_schema.partitionswhere |partition_name|table_rows ++||0||1||1||1||1||0||0||0||0||0||0||0||||00對(duì)分區(qū)表可以通過(guò)ALTERTABLEptEXCHANGEPARTITIONpWITHTABLEnt命令將一個(gè)交換的分區(qū)表和目標(biāo)表必須結(jié)構(gòu)完全相同，包括字段，類型，索引，引擎必須完全一樣PARTITIONBYRANGE(id)(PARTITIONp0VALUESLESSTHAN(50),PARTITIONp1VALUESLESSTHAN(MAXVALUE));QueryOK,0rowsaffected(1.34mysql>insertintoe(id,fname)MySQL表分區(qū)mysql>ALTERTABLEe2REMOVEQueryOK,0rowsaffected(0.90sec)Records:0Duplicates:0Warnings:mysql>ALTERTABLEeEXCHANGEPARTITIONp0WITHTABLEQueryOK,0rowsaffected(0.28mysql>SELECTPARTITION_NAME,FROMWHERETABLE_NAME= |PARTITION_NAME|| |p0|0|p1|0|p2|0|p3|3?mysql>select*from? ?|id|fname|lname? |10||||20||| ##再次執(zhí)行后數(shù)QueryOK,0rowsaffected(0.01mysql>select*from |id|fname|lname |10| | |20| | |170| | |180| | |190| | 5rowsinset(0.00mysql>select*fromEmptyset(0.00mysql>createtablee3(idint,fnamevarchar(30),lname2QueryOK,0rowsaffected(0.02mysql>altertableeexchangepartitionp3withtablemysql>createtablee3(idintnotnull,fnamevarchar(30),lnameQueryOK,0rowsaffected(0.04mysql>altertableeexchangepartitionp3withtableERROR1736(HY000):TableshavedifferentMySQL表分區(qū)否則只能用WITHOUTVALIDATION來(lái)跳過(guò)驗(yàn)證環(huán)節(jié)mysql>INSERTINTOe2VALUES(51,"Ellen",QueryOK,1rowaffected(0.08mysql>ALTERTABLEeEXCHANGEPARTITIONp0WITHTABLEERROR1707(HY000):Foundrowthatdoesnotmatchthemysql>ALTERTABLEeEXCHANGEPARTITIONp0WITHTABLEe2WITHOUTQueryOK,0rowsaffected(0.02mysql>CREATETABLEes(idINTNOTNULL,fnameVARCHAR(30),lname PARTITIONBYRANGESUBPARTITIONBYKEYSUBPARTITIONS2(PARTITIONp0VALUESLESSTHAN(50), PARTITIONp1VALUESLESSTHAN(100),PARTITIONp2VALUESLESSTHAN(150),PARTITIONp3VALUESLESSTHAN(MAXVALUE));QueryOK,0rowsaffected(2.76mysql>CREATETABLEes2LIKEQueryOK,0rowsaffected(1.27mysql>ALTERTABLEes2REMOVEmysql>ALTERTABLEesEXCHANGEPARTITIONp3sp0WITHQueryOK,0rowsaffected(0.29mysql>ALTERTABLEesEXCHANGEPARTITIONp3WITHERROR1704(HY000):Subpartitionedtable,usesubpartitioninsteadofMySQL表分區(qū) mysql>select*frome |id|fname|lname |10| | |20| | mysql>altertableetruncatepartitionmysql>select*fromeEmptyset(0.00通過(guò)showcreatetablemysql>showcreatetable |Table|Create| `id`int(11)NOT(PARTITIONp0VALUESLESSTHAN(50)ENGINE=PARTITIONp1VALUESLESSTHAN(100)ENGINE=PARTITIONp2VALUESLESSTHAN(150)ENGINE=PARTITIONp3VALUESLESSTHANMAXVALUEENGINE=InnoDB)*/通過(guò)showtablestatusmysql>showtablestatuslike

|Name|Engine|Version|Row_format|Rows|Avg_row_length|Data_length|Max_data_length|Index_length| Auto_increment| | |Check_time| |Checksum|Create_options|Comment

|e |InnoDB| 10|Dynamic 3| 21845| 65536| |latin1_swedish_ci|

0 0NULL|

0 |MySQL表分區(qū)通過(guò)information_schema.partitions系統(tǒng)表來(lái)查看分區(qū)表的具體信 SUBPARTITION_METHOD|PARTITION_EXPRESSION|SUBPARTITION_EXPRESSION|INDEX_LENGTH|DATA_ |CREATE_TIME |UPDATE_TIME |CHECK_TIME|CHECKSUM|MENT|NODEGROUP|TABLESPACE_NAME | | | | 1 NULL|| | | | 0 0 16384 NULL0

NULL

| | |

| |

| | 2

NULL||

|

| | 0

0 16384

NULL0

NULL

| | |

| |

| | 3

NULL||

|

| | 0

0 16384

NULL0

NULL

| | |

| |

| | 4

NULL||

|

|

|

3 5461

16384NULL

0 |

NULL

|