Skip to content
Tagged articles

open files limit

5 articles · Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 14, 2021 · Databases

Testing MySQL open_files_limit: Which Configuration Takes Effect – my.cnf, systemd Service, or Docker Limits

This article presents a systematic investigation of MySQL's open_files_limit setting across three scenarios—conflict between my.cnf and systemd service, effectiveness when using mysqld_safe, and the impact of Docker's own limits—revealing which source actually controls the maximum number of open files.

MySQLResource Limitscgroup
0 likes · 10 min read
Testing MySQL open_files_limit: Which Configuration Takes Effect – my.cnf, systemd Service, or Docker Limits
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.

ConfigurationMySQLdatabase tuning
0 likes · 6 min read
How MySQL Adjusts open_files_limit, max_connections, and table_open_cache When System Resources Are Insufficient