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.

SecurityBasicAuth

Responses

200

HTTP Request was successful.

Response Schema: application/json

	object
	object

get/get_database_optimizations

Request samples

whmapi1 --output=jsonpretty \
  get_database_optimizations

Response samples

application/json

{"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
}
}