-
Notifications
You must be signed in to change notification settings - Fork 845
Changes in AliSQL 5.6.32 (2016 10 14)
AliSQL edited this page Oct 14, 2016
·
2 revisions
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.
Description:
Support TokuDB storage.
Parameters:
no
Usage:
create table t(id int)engine=tokudb;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:
- 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;