Edit SQL Configuration — Simple & Complete Guide

Overview

Use this interface to change your server’s MySQL or MariaDB configuration. Saving changes will restart the database service. Not every option appears on every version; the page only shows what your engine supports. Size fields accept units like K, M, G, P, and E; if no unit is given, the value is treated as bytes.

Optimization Suggestions

The page can propose optimized values based on usage. You may apply all suggestions at once, or open the optimization menu for a single setting and apply it individually. You can also restore defaults or revert the last change from the icons beside each field.

Common Settings You Can Adjust

Logging

• General Logging — Enable/disable the general query log; set a custom General Log File name if needed.
• Error Log File Name — Path/name of the error log; Error Log Verbosity (MySQL 5.7+) controls detail level.
• Slow Query Log — Turn the slow log on/off and set Long Query Time; provide a Slow Query Log File Name.
• Log Output — Choose File, Table, or both.

Connections & Timeouts

• Max Connections — Maximum concurrent client connections.
• Max Connect Errors — Failed attempts before a client is blocked.
• Wait Timeout / Interactive Timeout — Seconds to keep idle connections open.
• Thread Cache Size — How many threads to keep cached for reuse.

Memory, Buffers & Temporary Data

• InnoDB Buffer Pool Size — Main InnoDB cache (usually 50–85% of RAM, depending on workload).
• InnoDB Buffer Pool Instances — Number of instances; only effective for ≥1 GB pool (deprecated/removed in newer MariaDB versions).
• InnoDB Log Buffer Size / InnoDB Log File Size — Controls redo logging behavior.
• Read Buffer Size / Read Random Buffer Size / Sort Buffer Size — Per-session buffers used by MyISAM/operations.
• Temporary Table Size and Max Heap Table Size — In-memory temp tables; the smaller of the two limits applies.
• Open Files Limit — Maximum file descriptors for the server.
• Max Allowed Packet — Largest permitted packet/intermediate string (e.g., big uploads or queries).

Performance & Caching

• Performance Schema — Enable/disable instrumentation for detailed performance analysis.
• Query Cache Size / Query Cache Type — Available in MariaDB and older MySQL (deprecated in MySQL 5.7+). Consider leaving disabled on modern setups.

Editing Tips

• Change a few related values at a time (for example, buffer pool + log file sizes), then monitor load and memory.
• Prefer enabling the slow query log briefly to locate problem queries, then tune indexes or code.
• Remember that some settings are per-connection buffers; raising them affects total memory use under concurrency.

Apply & Restart

1. Review your changes on the page (and any suggestions you accepted).
2. Click Save. The service will restart to apply the new configuration.

Example: my.cnf Snippet

[mysqld]
# Connections & timeouts
max_connections = 300
wait_timeout    = 600
interactive_timeout = 600

# InnoDB cache & logs
innodb_buffer_pool_size  = 8G
innodb_log_file_size     = 1G
innodb_log_buffer_size   = 64M

# Packets & temps
max_allowed_packet       = 256M
tmp_table_size           = 256M
max_heap_table_size      = 256M

# Slow log
slow_query_log           = 1
long_query_time          = 1.0
slow_query_log_file      = /var/log/mysql/slow.log
log_output               = FILE

Restart from Shell (Optional)

# Restart the SQL service as root
/scripts/restartsrv_mysql   # or: /scripts/restartsrv_mysqld

Summary

• Edit logging, timeouts, memory, cache, and performance options from one page.
• Use built-in optimization suggestions carefully; revert or restore defaults if needed.
• Values can include units like K/M/G; saving restarts the service.
• Test after each change and monitor performance and memory usage.

Reference: Official “Edit SQL Configuration” docs (overview, optimization suggestions, and setting descriptions and defaults).