Do Not Upgrade to Any Version of MySQL After 8.0.37

Or just don't create 10,000 tables.

10000 tables under one roof are by no means a large number.

Well designed, normalized handcrafted schemas can have hundreds of tables (many basic datatypes, many entities with a few many to many relations each).

Then mechanisms that create and copy tables automatically (e.g. by time intervals; to segregate versions or epochs or instances of something important; as snapshots or temporary duplicates or backups) can easily increase table count by two or more orders of magnitude.

Yep and if there's a limit, it should be documented and going past that should gracefully fail with an error, not a surprise crash...

There are also plenty of multitenant apps out there that have the same set of tables (with their own data) duplicated across all schemas.

Let me play Stallman for a moment: the system should serve me, not the other way around

I mean if that's your fetish.

I seriously laughed at this, well played

Use MariaDB. Or, even better, switch to PostgreSQL.

Oops... Would be interesting to see what is the cause of the problem