MySQL Forums
Forum List  »  MyISAM

[Errcode: 122] … Can't create/write to file '/tmp/#sql_6700_0.MYI'
Posted by: Jacques Guiffo
Date: October 06, 2010 01:29AM

Hi members

For some time now as the users of my multiples sites are growing, I am having this type of error almost everything day [ ….Can't create/write to file '/tmp/#sql_6700_0.MYI' (Errcode: 122) ] which block all the pages query to continue.

NB: I have double check with my server and my VPS plan doesn’t seem to have a storage issue.

Type of error message I get:

(

... NOW()) AND a.cid = 1 GROUP BY a.aid ORDER BY a.cton DESC LIMIT 0, 20Can't create/write to file '/tmp/#sql_6700_0.MYI' (Errcode: 122)

)

Please can somebody help or advice on this?

More information:
Operating system: Linux
Architecture x86_64: MySQL version 5.0.91-community
Apache version: 2.2.16
PHP version: 5.2.9

Thanks and regards
Jacques

Options: ReplyQuote


Subject
Views
Written By
Posted
[Errcode: 122] … Can't create/write to file '/tmp/#sql_6700_0.MYI'
9757
October 06, 2010 01:29AM


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.