I'm having this issue in my production system where it appears that only 1 query can execute with a temporary table at a time, and all other queries that require a temporary table are getting stuck in a "waiting for metadata lock" state.

This is causing an issue when the executing query is taking a considerable time to execute, and bots/crons then consume all available connections until the system crashes, I log into the system and kill the stalled query and all other queries just execute.

Is there a setting that I can use to allow multiple temporary tables at the same time? Or is this a known problem where the creation of temporary table is not releasing the metadata lock until the deletion of the temporary table?