MySQL Bugs: #70826: --tmpdir_2 when first tmp dir disk usage gets too large

Bug #70826	--tmpdir_2 when first tmp dir disk usage gets too large
Submitted:	5 Nov 2013 21:30	Modified:	7 Nov 2013 23:49
Reporter:	Jan Ksta	Email Updates:
Status:	Closed	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:
Mysql uses disk space for temporary tables http://dev.mysql.com/doc/refman/5.1/en/internal-temporary-tables.html. There is no way to limit this usage for mysql users and thus every mysql user can use all space on drive and paralyze server, especialy if tmp dir in on ssd drive (since it sould be for performance)

I suggest additional options to --tmpdir=:
--tmpdir1_limit_MB
--tmpdir_2

--tmpdir_2 would be used if --tmpdir is using more than --tmpdir_limit_MB. That would allow to still use ssd drive for relatively small on disk tmp tables and use other location on hard drive for those huge operations.

How to repeat:
---

Replaced it with all in one feature request http://bugs.mysql.com/bug.php?id=70857