mysql max connections

mysql max connections formula

mysql max connections calculator

max_connections = (Available RAM – Global Buffers) / Thread Buffers

available ram =MySQL ram

Global buffers

SHOW VARIABLES LIKE ‘%buffer%’;

innodb_buffer_pool, key_buffer_size, query_cache_size, etc

Available RAM = Global Buffers + (Thread Buffers x max_connections)

max_connections = (Available RAM – Global Buffers) / Thread Buffers

global buffers

innodb_buffer_pool_size

innodb_log_buffer_size

innodb_additional_mem_pool

net_buffer_length

total size of global buffers

thread buffers

sort_buffer_size

myisam_sort_buffer_size

read_buffer_size

join_buffer_size

read_mid_buffer_size

total threaded buffer size

generally 10% golbal buffers 1gb vs 100Mb.

max connections 151 default.

Ram= 1000+ (100*151)

1000+15100

1010+(112*27)

3024+1010=4GB.

otherway

check previous maxused connections

increase

check mysql error logs.

MySQL max connections formula

https://journeyontux.files.wordpress.com/2011/12/max_connection_measurements.xls