Changes in AliSQL 5.6.32 (2016 10 14)

AliSQL 5.6.32 Release Notes (2016-10-14)

Abstract

For the efficient compress, AliSQL now support tokuDB storage. it is very convenient to use according to CREATE TABLE synatx. Also the inventory center solution is released formally.

Functionality Added or Changed

1. Support TokuDB Storage

Description:

Support TokuDB storage.

Parameters:

no

Usage:

create table t(id int)engine=tokudb;

2. Hint Solution for Inventory

Description:

Usually Inventory Center has some hot commodity, corresponding to MySQL table records. So update the record will cause serious contention simultaneously.

This patch supply a queue for every hot commondity to serialize update according to statement hint.

Parameters:

1. rds_ic_reduce_hint_enable

System Variable Name	rds_ic_reduce_hint_enable
Variable Scope	global
Dynamic Variable	YES
Permitted Values	[OFF, ON]
Default	OFF
Description	enable the ic_reduce strategy when using hint

Usage:

update COMMIT_ON_SUCCESS ROLLBACK_ON_FAIL QUEUE_ON_PK 100 TARGET_AFFECT_ROW 1 t1 set c=c-1 where id=100;