<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 5/8/15 2:00 PM, Scott Moncrieff
wrote:<br>
</div>
<blockquote
cite="mid:CANEEQZ40M7BbegVAEpJViOAFSeDDzQTLO_CEvq70FdKzN-o_wg@mail.gmail.com"
type="cite">
<div dir="ltr">Apologies for the misinformation, it was nothing to
do with the ssh-agent file. The computer was not responding so
the directory did not update.
<div><br>
</div>
<div>When the disk starts to fill up, 6 files appear in /tmp</div>
<div>#sql_4ec_0.MYD </div>
<div>#sql4ec_2a3_0.frm </div>
<div>#sql4ec_2a3_0.MYI </div>
<div>#sql4ec_2a3_1.MYD </div>
<div>#sql_4ec_0.MYI </div>
<div>#sql4ec_2a3_0.MYD </div>
<div>#sql4ec_2a3_1.frm </div>
<div>#sql4ec_2a3_1.MYI</div>
</div>
</blockquote>
These are temporary files created by MySQL during large queries that
have more results than can be stored in the RAM allotted to it.
Depending on the query, this could easily fill up a hard drive.<br>
<br>
If you have not already tuned MySQL, you should look into the
settings available in /etc/my.cnf. The most relevant ones in your
case would probably be tmp_table_size and max_heap_table_size which,
for MyISAM tables, should probably be identical. I use a value of
500M for each, which means large queries that cannot be satisfied by
other caching methods can take up to 500 Mb before having to be
written to disk.<br>
<br>
If you have enough free RAM, you could set tmpdir to /dev/shm/, but
this is a less efficient way of doing the same thing.<br>
<blockquote
cite="mid:CANEEQZ40M7BbegVAEpJViOAFSeDDzQTLO_CEvq70FdKzN-o_wg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div><br>
</div>
I have cut out the middle of large sections of similar data for
clarity but the drive starts to fill up after the line:
<div><br>
</div>
<div><span
style="color:rgb(0,0,0);font-family:Consolas,Menlo,Monaco,'Lucida
Console','Liberation Mono','DejaVu Sans Mono','Bitstream
Vera Sans
Mono',monospace,serif;font-size:12px;line-height:21px">GetPlaybackURL/UNABLE/TO/FIND/LOCAL/FILE/ON/MythtvServer/9703_20150222193800.mpg.
File doesn't exist. Database metadata will not be removed.</span><br>
</div>
</div>
</blockquote>
This is most likely just a symptom of the drive already being full.<br>
</body>
</html>