New answers tagged max-connections
Before deciding on value for max_connections I suggest that you look at WHY it reached the max_connection condition. A bunch of sleeping/idle connection due to loose coding is very common cause. Check if you have proper value for wait_timeout and adjust if this is your symptom. Besides that, I would check for INSERT/UPDATE query that holds table locks for ...
You can use the below comment to check the connections: SELECT count(*) FROM INFORMATION_SCHEMA.PROCESSLIST; SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST order by DB; For MySql you can have the below value to optimize the performance innodb_log_file_size = 512M max_connections=2000 max_allowed_packet=64M wait_timeout=604800 key_buffer = 384M table_cache ...
I'd say 'Available RAM' means max memory mysql can claim. And 'Global buffers' would mean buffers like innodb_buffer_pool, key_buffer_size, query_cache_size, etc.
Top 50 recent answers are included