CPcpanel
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

Request

  • Base URL
    https://whm-server.tld:2087/json-api
  • Auth
    HTTP basic

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

Changes

No recorded changes to this operation across all 5 revisions of this API.