Since 8.0.24, [InnoDB] Operating system error number 24 in a file operation & Error number 24 means 'Too many open files' (Doc ID 2774469.1)

Last updated on JANUARY 11, 2022

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Symptoms are suddenly seeing lots of these messages in the error log, whereas prior versions with same configuration didn't have them:

Server was recently upgraded to 8.0.24. This problem is more likely on servers with many thousands of tables.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.