Scale up as you grow — whether you're running one virtual machine or ten thousand.

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.

I have created a stored procedure that uses recursion and so I need to set the max_sp_recursion_depth system variable in order for it to work. When I try setting it via the console, I get the following error:
set global max_sp_recursion_depth=1
[42000][1227] Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
I’ve also tried setting it using doctl but I get the following error:
doctl databases configuration update <cluster_id> -e "mysql" --config-json '{"max_sp_recursion_depth": 1}'
Error: PATCH https://api.digitalocean.com/v2/databases/<cluster_id>/config: 422 (request "<req_id>") the mask must be set with which fields are being updated
How can I change system variables on DigitalOcean Managed MySQL Databases?
hbarnard
keneucker
keneucker
rich
santoshpatil
Aspiresoftserv
Yakin
Thejaswini-Rao-U
775c69c916d345a7a367d867078ccb
mayricoak
ndam
bc2f52583874402a988f587c00195d