Tag

File Handles

1 views collected around this technical thread.

Aikesheng Open Source Community

Oct 8, 2021 · Databases

Diagnosing Sudden Increase in MySQL File Handle Count

This article explains how to diagnose a sudden rise in MySQL file handle usage by reproducing the issue with large tables, using Linux perf to trace open system calls, analyzing hash join behavior, and querying performance_schema.file_instances to pinpoint the underlying cause.

DiagnosisFile HandlesHash Join

0 likes · 2 min read

Diagnosing Sudden Increase in MySQL File Handle Count

Aikesheng Open Source Community

Sep 11, 2020 · Databases

Recovering Accidentally Deleted InnoDB .ibd Files Using Procfs File Handles

This article demonstrates how to recover mistakenly deleted InnoDB .ibd files by locating the open file handle through Linux procfs, locking database traffic, copying the hidden file, and restoring it to a running MySQL instance.

Data recoveryFile HandlesInnoDB

0 likes · 3 min read

Recovering Accidentally Deleted InnoDB .ibd Files Using Procfs File Handles