Databases
MySQL Databases
Return MySQL database optimizations
This function retrieves available database optimizations.
Warning:
On some servers, this function may return a large amount of output. We strongly suggest that you filter and sort the output.
Important:
The system disables this function when you have not configured remote MySQL, and you've disabled the MySQL/MariaDB and PostgreSQL roles.
get/get_database_optimizations
Response
HTTP Request was successful.
Example response
{
"data": {
"payload": [
{
"name": "innodb_sort_buffer_size",
"reason": "Your system's peak theoretical memory allocation is too high and may cause instability.",
"value": "2M"
}
]
},
"metadata": {
"command": "get_database_optimizations",
"reason": "OK",
"result": 1,
"version": 1
}
}