MySQL Forums :: Performance :: #1 - Can't create/write to file 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (Errcode: 17)


Advanced Search

Re: #1 - Can't create/write to file 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (Errcode: 17)
Posted by: Paul Singleton ()
Date: October 19, 2007 06:07AM

Deleting 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (or whatever) will get around the problem in the short term but won't stop it happening again.

(I am sure that defragmenting is irrelevant but harmless)

I believe there is a conflict between the way MySQL creates and deletes temporary files and various "resident" antivirus scanners, including McAfee and AVG 7.5

This is hard to test as the problem is somehow intermittent, but if you have a repeatable test case, try switching your resident virus checker off. I read a report elsewhere that someone attributed the problem to McAfee: I use AVG and the problem went away with AVG off and came back when I switched it back on...

So I created a new temp dir (C:\Program Files\MySQL\tmp) and specified this in my.ini

[mysqld]
...
tmpdir="C:/Program Files/MySQL/tmp/"

and then excluded this from AVG's Resident Shield scan.

FWIW I think MySQL should either cope better with this (maybe newer versions do), or explain it in their setup instructions (ditto).

Options: ReplyQuote


Subject Views Written By Posted
#1 - Can't create/write to file 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (Errcode: 17) 19749 young sun kim-walker 08/24/2007 05:32AM
Re: #1 - Can't create/write to file 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (Errcode: 17) 20258 Ron Scott 08/26/2007 12:12PM
Re: #1 - Can't create/write to file 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (Errcode: 17) 11059 young sun kim-walker 08/30/2007 11:06PM
Re: #1 - Can't create/write to file 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (Errcode: 17) 7584 Pavan Madishetty 06/01/2008 12:58AM
Re: #1 - Can't create/write to file 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (Errcode: 17) 8238 Ben Orlowitz 08/31/2007 10:15PM
Re: #1 - Can't create/write to file 'C:\WINDOWS\TEMP\#sql_e7c_0.MYD' (Errcode: 17) 16432 Paul Singleton 10/19/2007 06:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.