Bug #94025 TMPDIR not respected on Windows 10 with MySQL Server 8.0.14
Submitted: 24 Jan 2019 4:04 Modified: 28 Feb 2019 14:23
Reporter: J Donley Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Windows Severity:S2 (Serious)
Version:8.0.14 OS:Windows (1803)
Assigned to: CPU Architecture:x86

[24 Jan 2019 4:04] J Donley
Description:
After setting tmpdir value to a directory in a drive that is not C:, the setting is ignored. Temp files are always written to C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp

The issue is present through MySQL Client, Shell and Workbench.

How to repeat:
Against a table with a few million records, run a query that results in paging and storage of temporary data files on Windows 10. 

Expected: Files written to location specified in tmpdir
Actual: Files written to C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp
[28 Jan 2019 14:23] MySQL Verification Team
Thank you for the bug report. Is there error messages in your err log file about temporary files?. Thanks.
[28 Jan 2019 14:23] MySQL Verification Team
Thank you for the bug report. Is there error messages in your err log file about temporary files?. Thanks.
[28 Jan 2019 16:16] MySQL Verification Team
Forgot to mention I couldn't repeat using the tmpdir with forward slash like: tmpdir=d:/tmp/mysql.
[1 Mar 2019 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".