Nov 10, 2018

Per-thread configuration values in MySQL

It is important to pay attention to per-thread values in  MySQL. If for example you change something like join_buffer_size from 2M to 4M, it can increase mysql’s max memory utilization by 300M as per default 150 mysql’s max_connections value. If you have 188 connections, it can increase 188*2M=376M.