MySQL Bugs: #50291: Improvements to tmpdir

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

It looks like Bug #53119, Bug #60036 and Bug #69151 are duplicates of this bug

This would be really, really useful