Bug #50291 Improvements to tmpdir
Submitted: 12 Jan 2010 20:55
Reporter: Andrew Hutchings Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[12 Jan 2010 20:55] Andrew Hutchings
Description:
If a server is using tmpfs for tmpdir a large administrative query (such as a large delete) could fill it very quick with binlog cache (or other temporary files) and cause the query to fail.

See suggested fix for possible solutions.

How to repeat:
.

Suggested fix:
1. Make tmpdir a session variable so administrative queries can be moved to a disk based storage
or
2. Make temporary files flow onto the next path (ie. split files) if multiple paths are provided.  So tmpfs is the primary tmp and a disk based path is the secondary.
[3 Dec 2014 7:13] Daniƫl van Eeden
It looks like Bug #53119, Bug #60036 and Bug #69151 are duplicates of this bug