<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 08/05/15 08:16, Scott Moncrieff
wrote:<br>
</div>
<blockquote
cite="mid:CANEEQZ6jR-0qtjMGqWvSW5E3P6zXsYr93=qU=wOvVBqRUEvi8g@mail.gmail.com"
type="cite">
<div dir="ltr">Whilst the drive is filling up, /tmp has a folder
ssh-P5Nw6CXpmdb which contains a single file - agent.1506
<div><br>
</div>
<div>It is this file which has zero bytes and then grows to fill
the drive.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 8 May 2015 at 07:55, Scott Moncrieff
<span dir="ltr"><<a moz-do-not-send="true"
href="mailto:scottcmoncrieff@gmail.com" target="_blank">scottcmoncrieff@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Thank you, I will explore all of this but
unfortunately not until after work tonight!
<div><br>
</div>
<div>The drive is not partitioned, the system runs on a
128gb SSD,10.2 gb used now I have restored an older
system backup and I have 4 x 3TB drives, 1 for
recordings and 1 for Video library and the other 2 are
backups updated using rsync. </div>
<div><br>
</div>
<div>I have optimised the database tables again (did it
last night as well)</div>
<div><br>
</div>
<div>From the log it looks like it has been doing this for
most of the night but has been stable for the last 20
minutes at least, drive just starting to fill up now. du
shows that it is /tmp/ that is filling up but will
investigate more tonight.</div>
<span class="HOEnZb"><font color="#888888">
<div><br>
</div>
</font></span></div>
</blockquote>
</div>
</div>
</blockquote>
<br>
/tmp space is filling up.<br>
mysql writes tmp tables to /tmp by default, if you have very little
space left, mysql will fill the disk, crash the query session, which
releases the space. Rinse and repeat.<br>
<br>
If you have another mount point with space, you can try altering the
tmpdir var in my.cnf and restarting mysql.<br>
<br>
Or free some space on /.<br>
<pre class="moz-signature" cols="72">--
'ooroo
Stinga...(:)-)
---------------------------------------------------
Email: <a class="moz-txt-link-abbreviated" href="mailto:stinga+mythtv@wolf-rock.com">stinga+mythtv@wolf-rock.com</a> o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------</pre>
</body>
</html>