Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
For bugs related to Red Hat Enterprise Linux 5 product line. The current stable release is 5.10. For Red Hat Enterprise Linux 6 and above, please visit Red Hat JIRA https://issues.redhat.com/secure/CreateIssue!default.jspa?pid=12332745 to report new issues.

Bug 455619

Summary: tmpdir variable not honored for internally created temporary tables
Product: Red Hat Enterprise Linux 5 Reporter: Patrice Guay <froggy>
Component: mysqlAssignee: Tom Lane <tgl>
Status: CLOSED ERRATA QA Contact:
Severity: medium Docs Contact:
Priority: low    
Version: 5.2CC: artms, byte, hhorak, kvolny, patrickm
Target Milestone: rc   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-09-02 09:46:29 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Patch to fix the issue none

Description Patrice Guay 2008-07-16 17:19:51 UTC 
Description of problem:

The MySQL server is creating temporary tables for filesort in the working
directory instead of the specified tmpdir directory.

Version-Release number of selected component (if applicable):
5.0.45-7.el5

This bug is documented at the mysql bugtracker:
http://bugs.mysql.com/bug.php?id=30287

This bug has been fixed in mysql 5.0.48
Comment 1 Patrice Guay 2008-07-16 17:19:51 UTC 
Created attachment 311974 [details]
Patch to fix the issue
Comment 6 errata-xmlrpc 2009-09-02 09:46:29 UTC 
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHSA-2009-1289.html