[improve] Make the schema change memory space adaptive

[improve] Make the schema change memory space adaptive #9711