open_files_limit

JD Retail Technology

Oct 27, 2023 · Operations

Investigation of Java Service Crashes at Midnight Due to Cron and Open Files Limit in CentOS Containers

The article analyzes why a Java service repeatedly crashes around midnight in test environments, tracing the issue through system limits, Java version checks, cron job execution, strace logs, and Linux OOM killer behavior, and finally proposes configuration and version upgrades to prevent the failures.

CentOSJavaLinux OOM Killer

0 likes · 25 min read

Investigation of Java Service Crashes at Midnight Due to Cron and Open Files Limit in CentOS Containers

Aikesheng Open Source Community

Aug 16, 2022 · Databases

Resolving Xtrabackup Backup Failures Caused by Too Many Open Files in MySQL

This article explains why Percona Xtrabackup backups of MySQL 5.7 can fail with "Too many open files" errors, demonstrates how to reproduce the issue under both non‑root and root users, analyzes the open‑files‑limit settings, and provides practical solutions to adjust system and user limits for successful backups.

BackupDatabase AdministrationLinux

0 likes · 12 min read

Resolving Xtrabackup Backup Failures Caused by Too Many Open Files in MySQL

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.

DockerMySQLcgroup

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

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.

Database TuningMySQLconfiguration

0 likes · 6 min read

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