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 Tuningmax_connections

0 likes · 6 min read

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

Efficient Ops

Dec 20, 2020 · Operations

Boost Server Performance: CPU, Memory, Disk, Network & Concurrency Optimizations

This article summarizes Tao Hui's 2020 GOPS Global Operations Conference talk, covering practical techniques for optimizing basic resources, improving network efficiency, reducing request latency, and scaling system concurrency to achieve higher throughput and lower latency in modern distributed services.

Operationsnetwork efficiencysystem resources

0 likes · 23 min read

Boost Server Performance: CPU, Memory, Disk, Network & Concurrency Optimizations

ITPUB

Nov 2, 2016 · Operations

Monitor Linux System Resources with Simple Shell Scripts

This guide shows how to write Bash functions that retrieve process IDs, CPU, memory, file‑descriptor usage, port status, system load and disk space on a Linux server, and how to combine them with conditional checks to generate alerts when thresholds are exceeded.

LinuxOperationsShell

0 likes · 16 min read

Monitor Linux System Resources with Simple Shell Scripts