MySQL crashing at about 70k open files

The issue is a Mysql bug (https://bugs.mysql.com/bug.php?id=94185 )

Anyway, some tuning mitigated the issue and stopped the number of open files to grow.

Specifically, we set:

innodb_lru_scan_depth=100
innodb_flushing_avg_loops=5
thread_cache_size=216

Fixed as of the upcoming 8.0.16 release, and here's the changelog entry:

Static thread local variables defined at the wrong scope were not released at thread exit.

Related