Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If <code>rm -rf</code> is slow, perhaps you are using a "sync" option or similar, which is writing to the disk too often. On Linux ext3 with normal options, <code>rm -rf</code> is very quick.</p> <p>One option for fast removal which would work on Linux and presumably also on various Unixen is to use a loop device, something like:</p> <pre><code>hole temp.img $[5*1024*1024*1024] # create a 5Gb "hole" file mkfs.ext3 temp.img mkdir -p mnt-temp sudo mount temp.img mnt-temp -o loop </code></pre> <p>The "hole" program is one I wrote myself to create a large empty file using a "hole" rather than allocated blocks on the disk, which is much faster and doesn't use any disk space until you really need it. <a href="http://sam.nipl.net/coding/c-examples/hole.c" rel="nofollow noreferrer">http://sam.nipl.net/coding/c-examples/hole.c</a></p> <p>I just noticed that GNU coreutils contains a similar program "truncate", so if you have that you can use this to create the image:</p> <pre><code>truncate --size=$[5*1024*1024*1024] temp.img </code></pre> <p>Now you can use the mounted image under mnt-temp for temporary storage, for your build. When you are done with it, do this to remove it:</p> <pre><code>sudo umount mnt-temp rm test.img rmdir mnt-temp </code></pre> <p>I think you will find that removing a single large file is much quicker than removing lots of little files!</p> <p>If you don't care to compile my "hole.c" program, you can use dd, but this is much slower:</p> <pre><code>dd if=/dev/zero of=temp.img bs=1024 count=$[5*1024*1024] # create a 5Gb allocated file </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POUnix: fast 'remove directory' for cleaning up daily builds
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSam Watkins
    1. USSam Watkins
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis sounds like a 'special' solution. But if it works on AIX/solaris I can give it a try. For Linux I do not have this problems since the harddisk is such big that it is not an issue.
      singulars
      1. PO
      1. This table or related slice is empty.
    2. COyou can also use `dd`'s "seek" command and a count of zero to create files with holes.
      singulars
      1. PO
      1. USmihi
    3. COYou can do this sort of thing on any OS that has support for loop devices or logical volume management - create a temporary file system in a file or on the LvM, do your work in it, then just delete the whole filesystem (remove the file), which should be almost instantaneous, like deleting a large DVD image or whatever from your disk. The example commands I gave are for Linux, but the same thing should be possible on any *nix works it's salt, maybe even on 'doze.
      singulars
      1. PO
      1. USSam Watkins
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload