Provide list of steps you will perform
The steps to describe in the proposal, sorry, 300 characters did not reach me.
Proposal:
Hello, I'm Moses Cedeño. I have more than 3 years of experience in databases, design, programming and software development in general.
With the knowledge, skills and experience I have, I consider that I meet the requirements to carry out your project.
Steps:
1) Use a COMPLETE PROCESLIST SHOW instead of SHOW PROCESSLIST to be able to see the complete query for each thread ...
2) Check each thread if there is any preparation query that is blocking the others.
3) Determine the error that is being presented and apply the possible solutions depending on the cases, although from what I see, you probably have one of these two cases:
Case 1: The error that occurs is because the temporary tables are used on a disk basis for a selection and these are competing with each other for the space with their usual data.
Assign tmpdir to another disk.
Case 2: The error is because the temp table is landing in / tmp on the root partition and is running out of space.
Solution: Create the RAM disk.
Other cases: For other cases, I can solve it equally, but I would have to see what is the result of the COMPLETE SHOW PROCESSLIST.
4) Check that the error has been solved.