review_settings
Analyze MySQL configuration settings to identify performance issues and receive optimization recommendations for memory, InnoDB, connections, and logging parameters.
Instructions
Review MySQL configuration settings and get recommendations.
Analyzes key performance-related settings:
Memory settings (buffer pool, sort buffer, join buffer)
InnoDB settings
Connection settings
Query cache settings (if applicable)
Logging settings
Compares against best practices and system resources.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| category | No | Category of settings to review | all |
| include_all_settings | No | Include all settings, not just performance-related ones |
Input Schema (JSON Schema)
{
"properties": {
"category": {
"default": "all",
"description": "Category of settings to review",
"enum": [
"all",
"memory",
"innodb",
"connections",
"logging",
"replication"
],
"type": "string"
},
"include_all_settings": {
"default": false,
"description": "Include all settings, not just performance-related ones",
"type": "boolean"
}
},
"required": [],
"type": "object"
}