<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello,</p>
<p>I have problem where when I make delete calls to table disk usage
doesn't decrease.<br>
</p>
<p>> erlang:system_info(otp_release).<br>
"19"<br>
My Create Table:<br>
</p>
<pre class="code highlight" lang="erlang"><span id="LC128" class="line" lang="erlang"> <span class="nn">mnesia</span><span class="p">:</span><span class="nf">create_table</span><span class="p">(</span><span class="nv">Tbl</span><span class="p">,</span></span>
<span id="LC129" class="line" lang="erlang"> <span class="p">[</span></span>
<span id="LC131" class="line" lang="erlang"> <span class="p">{</span><span class="n">type</span><span class="p">,</span> <span class="n">set</span><span class="p">},</span></span>
<span id="LC132" class="line" lang="erlang"> <span class="p">{</span><span class="n">attributes</span><span class="p">,</span> <span class="p">[</span><span class="n">rowId</span><span class="p">,</span> <span class="n">row1</span><span class="n"></span><span class="p">,</span> row2<span class="n"></span><span class="p">,</span> row3<span class="n"></span><span class="p">,</span> <span class="n">createdOn</span><span class="p">]},</span></span>
<span id="LC133" class="line" lang="erlang"> <span class="p">{</span><span class="n">disc_only_copies</span><span class="p">,</span> <span class="p">[</span><span class="nb">node</span><span class="p">()]}</span></span>
<span id="LC134" class="line" lang="erlang"> <span class="p">]).
</span></span>
My Delete Call:
<span id="LC464" class="line" lang="erlang"><span class="nf">
async_dyn_delete</span><span class="p">(</span><span class="nv">Tbl</span><span class="p">,</span> <span class="nv">Results</span><span class="p">)</span> <span class="o">-></span></span>
<span id="LC465" class="line" lang="erlang"> <span class="nv">DELETE</span> <span class="o">=</span> <span class="k">fun</span><span class="p">()</span> <span class="o">-></span></span>
<span id="LC466" class="line" lang="erlang"> <span class="nn">lists</span><span class="p">:</span><span class="nf">foreach</span><span class="p">(</span><span class="k">fun</span><span class="p">(</span><span class="nv">Object</span><span class="p">)</span> <span class="o">-></span></span>
<span id="LC469" class="line" lang="erlang"> <span class="p">{_,</span> <span class="nv">Key</span><span class="p">,_,_,_,_,_}</span> <span class="o">=</span> <span class="nv">Object</span><span class="p">,</span></span>
<span id="LC470" class="line" lang="erlang"> <span class="nn">mnesia</span><span class="p">:</span><span class="nf">delete</span><span class="p">(</span><span class="nv">Tbl</span><span class="p">,</span> <span class="nv">Key</span><span class="p">,</span> <span class="n">write</span><span class="p">)</span></span>
<span id="LC471" class="line" lang="erlang"> <span class="k">end</span><span class="p">,</span> <span class="nv">Results</span><span class="p">)</span></span>
<span id="LC472" class="line" lang="erlang"> <span class="k">end</span><span class="p">,</span></span>
<span id="LC473" class="line" lang="erlang"> <span class="nn">mnesia</span><span class="p">:</span><span class="nf">sync_transaction</span><span class="p">(</span><span class="nv">DELETE</span><span class="p">).</span></span>
Storage on Disk for table is not changing with the deletes.
Do I delete differently???
Thank you,
Ben
</pre>
</body>
</html>