134 reputation
119
bio website ericmartindale.com
location Raleigh, NC
age 27
visits member for 5 years, 4 months
seen Oct 20 at 21:31

Wearer of many hats.


Jan
26
awarded  Teacher
Oct
19
awarded  Famous Question
Apr
16
awarded  Autobiographer
Nov
24
awarded  Popular Question
Jun
14
awarded  Notable Question
Dec
4
awarded  Popular Question
Jun
9
awarded  Commentator
Jun
9
comment MySQL Can't Create/Write To File
No, I have not been able to locate these files in the /tmp folder. I'm not sure how to capture them in time, before they are cleaned up?
Jun
8
awarded  Editor
Jun
8
comment MySQL Can't Create/Write To File
This is not a disk space issue, but that does not rule out a memory issue. The errors do refer to the same file.
Jun
8
revised MySQL Can't Create/Write To File
Added EXPLAIN results to question.
Jun
8
comment MySQL Can't Create/Write To File
No, none of the output is in text/blob format - it's all varchar and int fields. Interestingly enough, and this may help isolate the actual issue - I've noticed a second error that seems less frequent but still troublesome: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug [1135] I'm wondering what might be causing that, too. Also: I have edited in the EXPLAIN output of the query. It does look like it is using a filesort - which I am attributing to insufficient memory resources.
Jun
8
awarded  Scholar
Jun
8
accepted Apache crashing; “Too many open files in system”
Jun
8
comment MySQL Can't Create/Write To File
It's almost certainly an issue with tuning the temporary table size, but I'm very uncertain about which direction I want to tune it... and what exactly the best approach would be. Obviously, fixing it for the long term would involve refactoring the queries - but I'd like to get the server stable before that takes place. Any ideas on what the best angle of attack would be?
Jun
8
comment MySQL Can't Create/Write To File
Restarting the SQL server does resolve the issue.
Jun
8
asked MySQL Can't Create/Write To File
Jun
8
awarded  Supporter
Jun
8
comment Apache crashing; “Too many open files in system”
Okay, I think the more appropriate term is "worked around". ;P More interestingly (and consequently, new Question coming soon...) I've noticed that we're still running into some intermittent issues relating to some tuning of MySQL. My theory is that some small tuning of MySQL caused more on-disk files to be put into use, which cascaded down into Apache issues. Don't quote me on this.
Jun
5
answered Apache crashing; “Too many open files in system”