BestHub
Sign in
Tagged articles

max-connections

12 articles · Page 1 of 1
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Jun 12, 2026 · Databases

PostgreSQL Migration Pitfalls: From Rough Practices to Stable Management

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
PostgreSQL Migration Pitfalls: From Rough Practices to Stable Management
LuTiao Programming
LuTiao Programming
Jan 4, 2026 · Backend Development

Why ‘How Much Concurrency Can Spring Boot 3 Handle?’ Is Misleading – A Deep Dive into Max Connections

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.

Spring Bootconcurrencykeepalive
0 likes · 9 min read
Why ‘How Much Concurrency Can Spring Boot 3 Handle?’ Is Misleading – A Deep Dive into Max Connections
Aikesheng Open Source Community
Aikesheng Open Source Community
May 6, 2025 · Databases

Using GDB to Adjust MySQL max_connections Without Restart

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.

Database TuningMySQLSysbench
0 likes · 9 min read
Using GDB to Adjust MySQL max_connections Without Restart
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 11, 2021 · Databases

Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors

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 PoolingDatabase Administration
0 likes · 9 min read
Using MySQL 8.0 Administrative Connection Interface to Solve “Too Many Connections” Errors
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 2, 2021 · Databases

How MySQL Adjusts open_files_limit, max_connections, and table_open_cache When System Resources Are Insufficient

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.

ConfigurationDatabase TuningMySQL
0 likes · 6 min read
How MySQL Adjusts open_files_limit, max_connections, and table_open_cache When System Resources Are Insufficient
Open Source Linux
Open Source Linux
Apr 26, 2021 · Databases

How to Resolve MySQL Too Many Connections Errors by Raising max_connections

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.

ConfigurationDatabaseMySQL
0 likes · 4 min read
How to Resolve MySQL Too Many Connections Errors by Raising max_connections
Laravel Tech Community
Laravel Tech Community
Apr 20, 2021 · Databases

Diagnosing and Increasing MySQL Max Connections

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
Diagnosing and Increasing MySQL Max Connections
ITPUB
ITPUB
Dec 10, 2017 · Databases

How to Tune MySQL for Holiday Traffic Spikes: 3 Essential Tricks

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
How to Tune MySQL for Holiday Traffic Spikes: 3 Essential Tricks
dbaplus Community
dbaplus Community
Nov 19, 2017 · Databases

Why MySQL Throws ‘Too Many Connections’ and How to Fix It

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.

MySQLSlow QueryToo many connections
0 likes · 8 min read
Why MySQL Throws ‘Too Many Connections’ and How to Fix It