MySQL my.cnf Configuration

This page is original PmaControl documentation. It keeps a practical index structure for MySQL optimization work, without copying third-party content or depending on an external product.

Role

The my.cnf file should describe an operational intent: memory, logs, durability, network, security, and limits. Comments are useful when they explain why a value differs from the default.

Minimal Example

[mysqld]
max_connections = 300
innodb_buffer_pool_size = 12G
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
table_open_cache = 4000
open_files_limit = 65535

Check

SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
SHOW VARIABLES LIKE 'max_connections';
SHOW GLOBAL STATUS LIKE 'Max_used_connections';