We hope we can control the resource of MLSQL engine manually and without restarting.
We can do like this:

!resource add 10c;
!resource remove 10c;
!resource set 40c;

MLSQL Engine will calculate how many executors to add or remove:

floor(10/cores-every-executor)

and the memory will increase and down with the change of cores.

And this command should support Auth.

We have a resource table, and there are two operations:

select (query current cores and memory) 
update (add or remove cores)