Tagged articles
max_connections
13 articles · Page 1 of 1
This article outlines ten critical MySQL configuration parameters administrators should prioritize after installation, covering InnoDB buffer pool sizing, log file configuration, connection limits, flush methods, query cache disabling, binary logging, and DNS resolution skipping, with practical guidance on safe modification practices and version-specific considerations.
Database ConfigurationInnoDBMySQL
0 likes · 10 min read

The article analyzes common mistakes when moving from MySQL to PostgreSQL—such as oversized connection pools, blind max_connections tweaks, oversized transactions, idle‑in‑transaction connections, and indiscriminate indexing—and offers concrete, step‑by‑step guidance to achieve a stable, well‑tuned PostgreSQL deployment.
Connection PoolIndex OptimizationPerformance Tuning
0 likes · 14 min read

The article shows that Spring Boot itself does not limit concurrency; the true ceiling is set by Linux TCP parameters, Tomcat's acceptCount and maxConnections, its thread‑pool strategy, and KeepAlive settings, and it walks through source code, default values, and practical experiments to reveal where requests are blocked.
ConcurrencySpring BootTomcat
0 likes · 9 min read

This article explains how to troubleshoot and resolve the MySQL "Too many connections" error by using GDB to modify the max_connections parameter on a running MySQL 5.7 instance without restarting, including step‑by‑step commands, sysbench load testing, and two practical methods.
MySQLdatabase tuninggdb
0 likes · 9 min read

This guide walks through the complete process of modifying the max_connections setting for an AWS RDS MySQL instance by creating a custom parameter group, updating the parameter via the AWS CLI, binding the group to the instance, and restarting the database to apply the change.
AWSMySQLParameter Group
0 likes · 8 min read

The article explains why MySQL can hit the max_connections limit, introduces the MySQL 8.0 administrative connection interface and its configuration variables, demonstrates how to create a privileged user and test connection limits with code examples, and offers best‑practice recommendations to prevent connection saturation.
Administrative Connection InterfaceConnection PoolingMySQL
0 likes · 9 min read

This article explains how MySQL, when run by a non‑root user with limited system resources, automatically adjusts the open_files_limit, max_connections, and table_open_cache parameters by calculating required file descriptors, comparing them to system limits, and correcting the configuration values accordingly.
ConfigurationMySQLdatabase tuning
0 likes · 6 min read

This guide explains why MySQL reports "too many connections", shows how to check the current max_connections setting, compares default limits across MySQL versions, and provides four practical methods—including editing my.cnf, using SQL commands, modifying source code, and tweaking mysqld_safe—to increase the connection limit safely.
ConfigurationMySQLdatabase
0 likes · 4 min read

This guide explains how to identify MySQL max‑connection errors, check the current limit, and increase it using configuration files, global variables, source‑code changes, or mysqld_safe adjustments, with detailed commands and code examples for various MySQL versions.
Database ConfigurationMySQLPerformance Tuning
0 likes · 4 min read

This guide explains how to identify MySQL max_connections issues, check the current limit, and increase it via configuration files, runtime commands, source code changes, or mysqld_safe adjustments, covering version‑specific defaults and maximum caps.
ConfigurationMySQLdatabase
0 likes · 4 min read


ITPUBDec 10, 2017 · Databases
This article explains three practical MySQL performance‑tuning techniques—setting an appropriate max_connections value, allocating enough memory for temporary tables, and increasing the thread cache size—to help database servers survive the massive traffic surges of holiday shopping periods without downtime.
Holiday TrafficMySQLPerformance Tuning
0 likes · 11 min read

This article explains the root causes of MySQL’s “Too many connections” error—including max_connections limits, sleep connections, and slow queries—provides detailed parameter descriptions, shares real‑world troubleshooting cases, and offers practical solutions such as killing idle sessions, adjusting wait_timeout, and tuning InnoDB concurrency settings.
MySQLToo many connectionsmax_connections
0 likes · 8 min read

This guide explains the two main causes of MySQL error 1040—excessive traffic and a low max_connections setting—shows how to check current and historical connection limits, and provides a rule of thumb for configuring an optimal connection threshold.
Error 1040MySQLToo many connections
0 likes · 2 min read
