mysql分区表_mysql分表后如何查询_mysql 分区表 坑(3)

5.12 分区键不能是一个子查询。 A partitioning key may not be a subquery, even if that subquery resolves to an integer value or NULL

5.13 只有RANG和LIST分区能进行子分区。HASH和KEY分区不能进行子分区。

5.14 分区表不支持Key caches。

mysql>SETGLOBALkeycache1.key_buffer_size=128*1024;

QueryOK,0rowsaffected(0.00sec)

mysql>CACHEINDEXlogin,user_msg,user_msg_pINkeycache1;

+-----------------+--------------------+----------+---------------------------------------------------------------------+

|Table|Op|Msg_type|Msg_text|

+-----------------+--------------------+----------+---------------------------------------------------------------------+

|test.login|assign_to_keycache|status|OK|

|test.user_msg|assign_to_keycache|status|OK|

|test.user_msg_p|assign_to_keycache|note|Thestorageengineforthetabledoesn'tsupportassign_to_keycache|

+-----------------+--------------------+----------+---------------------------------------------------------------------+

3rowsinset(0.00sec)

5.15 分区表不支持INSERT DELAYED.

mysql>insertDELAYEDintouser_msg_pvalues(18156629,0,0,0,0,0,0,0,0,0);

ERROR1616(HY000):DELAYEDoptionnotsupportedfortable'user_msg_p'

5.16 DATA DIRECTORY 和 INDEX DIRECTORY 参数在分区表将被忽略。

这个限制应该不存在了：

mysql>CREATETABLEt1

->(idINTNOTNULL,

->uidINTNOTNULL,

->PRIMARYKEY(id)

->)

->PARTITIONBYRANGE(id)

->(PARTITIONp0VALUESLESSTHAN(5)ENGINE=MyISAMDATADIRECTORY='/tmp'INDEXDIRECTORY='/tmp',

->PARTITIONp1VALUESLESSTHAN(10)ENGINE=MyISAMDATADIRECTORY='/tmp'INDEXDIRECTORY='/tmp'

->);

QueryOK,0rowsaffected(0.01sec)

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-25161-3.html