MySQL Server RAM Optimization

Recommended server-side configuration to reduce MySQL memory usage. Adjust these in my.cnf (or equivalent) and restart MySQL.

InnoDB

# Use 50-70% of dedicated DB server RAM; reduce on shared hosts
innodb_buffer_pool_size = 256M
innodb_log_buffer_size = 16M

# Lower than default 151 if you do not need many concurrent connections
max_connections = 50

tmp_table_size = 32M
max_heap_table_size = 32M
join_buffer_size = 256K
sort_buffer_size = 256K

Query cache is removed in MySQL 8. If you are on MySQL 5.7 and use it, disable to avoid overhead:

query_cache_type = 0