SELECT PARTITION_NAME AS Name ,PARTITION_ORDINAL_POSITION AS Position ,PARTITION_METHOD AS Method ,PARTITION_EXPRESSION AS Expression ,PARTITION_DESCRIPTION AS Description ,TABLE_ROWS AS Rows ,CREATE_TIME AS CreateTime FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA='test' AND TABLE_NAME='tab';...
PARTITION_ORDINAL_POSITION:分区的顺序位置。 SUBPARTITION_ORDINAL_POSITION:子分区的顺序位置,如果表有子分区的话。 PARTITION_METHOD:分区的方法,例如RANGE、LIST、HASH等。 SUBPARTITION_METHOD:子分区的方法,如果表有子分区的话。 PARTITION_EXPRESSION:分区的表达式。 SUBPARTITION_EXPRESSION:子分区的表达式,如果表有子...
PARTITION_NAME: p0 SUBPARTITION_NAME:NULL PARTITION_ORDINAL_POSITION: 1 SUBPARTITION_ORDINAL_POSITION:NULL PARTITION_METHOD: RANGE SUBPARTITION_METHOD:NULL PARTITION_EXPRESSION: id SUBPARTITION_EXPRESSION:NULL PARTITION_DESCRIPTION: 10 TABLE_ROWS: 3 AVG_ROW_LENGTH: 5461 DATA_LENGTH: 16384 MAX_DATA_LENGTH...
PARTITION_ORDINAL_POSITION: 1 SUBPARTITION_ORDINAL_POSITION: NULL PARTITION_METHOD: RANGE SUBPARTITION_METHOD: NULL PARTITION_EXPRESSION: id SUBPARTITION_EXPRESSION: NULL PARTITION_DESCRIPTION: 10 TABLE_ROWS: 3 AVG_ROW_LENGTH: 5461 DATA_LENGTH: 16384 MAX_DATA_LENGTH: NULL INDEX_LENGTH: 0 DATA_FREE:...
PARTITION_ORDINAL_POSITION: 1 SUBPARTITION_ORDINAL_POSITION: NULL PARTITION_METHOD: RANGE SUBPARTITION_METHOD: NULL PARTITION_EXPRESSION: id SUBPARTITION_EXPRESSION: NULL PARTITION_DESCRIPTION: 10 TABLE_ROWS: 2 AVG_ROW_LENGTH: 8192 DATA_LENGTH: 16384 ...
CALL add_partition_mytest(); END || DELIMITER ; 查询mysql事件调度器是否开启 /* 查看定时器开关情况 */ show VARIABLES like 'event_scheduler'; /* 开启定时器开关 */ set GLOBAL event_scheduler = 1; 八、查看分区情况 SELECT partition_name, partition_ordinal_position, TABLE_Rows, table_schema ...
An NDB table which is not explicitly partitioned has one row in the PARTITIONS table for each data node in the NDB cluster. For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, SUBPARTITION_METHOD, SUBPARTITION_EXPRESSION, CREATE_TIME, UPDATE_TIME, CHECK_TIME, CHECKSUM, and...
PARTITION_ORDINAL_POSITION 分区在表中的位置,从1开始,会在分区添加,删除,重整使会发生编号 SUBPARTITION_ORDINAL_POSITION 子分区在分区中的位置 PARTITION_METHOD 分区类型,可以是 RANGE, LIST, HASH, LINEAR HASH, KEY, or LINEAR KEY SUBPARTITION_METHOD 子分区的类型,可以是HASH, LINEAR HASH, KEY, or LINEAR...
PARTITION_NAME The name of the partition. SUBPARTITION_NAME If the PARTITIONS table row represents a subpartition, the name of subpartition; otherwise NULL. For NDB: This value is always NULL. PARTITION_ORDINAL_POSITION All partitions are indexed in the same order as they are defined, ...
PARTITION_ORDINAL_POSITION: 1 SUBPARTITION_ORDINAL_POSITION:NULL PARTITION_METHOD: HASH SUBPARTITION_METHOD: NULL PARTITION_EXPRESSION: year(b) SUBPARTITION_EXPRESSION: NULL PARTITION_DESCRIPTION: NULL TABLE_ROWS: 0 AVG_ROW_LENGTH: 0 DATA_LENGTH: 16384 ...