Bug #60036 make tmpdir variable changeable during runtime
Submitted: 9 Feb 2011 6:57
Reporter: Bogdan Kecman Email Updates:
Status: Verified Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any

[9 Feb 2011 6:57] Bogdan Kecman
Sometimes one would need to change where temporary tables are being created without having to restart mysql server. It would be great if tmpdir variable could be changed in runtime.

How to repeat:
mysql> set global tmpdir = '/other/tmp2';
ERROR 1238 (HY000): Variable 'tmpdir' is a read only variable

Suggested fix:
[20 Nov 2013 10:36] martin fuxa
btw same with #53119
[3 Dec 2014 7:12] Daniƫl van Eeden
This looks like a duplicate of Bug #50291