We very strongly recommend against using SETGLOBAL with Enclave MySQL
Databases.

Indeed, using any configuration parameters added using SETGLOBAL will be
discarded if your Database is restarted (e.g. as a result of exceeding
Memory Limits, the underlying hardware crashing, or simply as a result
of a Database Scaling operation). In this scenario, unless your app
automatically detects this condition and uses SETGLOBAL again, your
custom configuration will no longer be present.

However, our support team is happy to accommodate reasonable configuration
changes so that they can be persisted across restarts (by adding them to a
configuration file). So, if you’re contemplating using SETGLOBAL, please
get in touch with Aptible Support instead.