registry.db getting rather obese (> 600MB) and updates very slow. Anything to do?

[Craig Treleaven]

Hi:

I can’t help but I have the same issue as you—uninstalls take a long time.  My registry:

$ ls -la /opt/local/var/macports/registry/
total 1453344
drwxr-xr-x     7 root  wheel        238 19 Jun 15:23 .
drwxr-xr-x@   17 root  admin        578 28 Feb  2017 ..
-rw-r--r--     1 root  wheel          0 19 Jun 15:20 .registry.lock
-rw-rw-r--     1 root  wheel          0 20 Nov  2014 .turd_MacPorts
drwxr-xr-x  4088 root  wheel     138992 19 Jun 15:21 portfiles
drwxr-xr-x   234 root  wheel       7956 29 May 09:12 portgroups
-rw-r--r--     1 root  wheel  744112128 19 Jun 15:23 registry.db

This is on a 2011 MacBook Pro (i7).

Craig

> On Jun 21, 2020, at 2:17 PM, Ken Cunningham <ken.cunningham.webuse at gmail.com> wrote:
> 
> On one of my systems, 10.5 PPC, things are taking a long time when uninstalling a port - like 4-5 minutes of heavy tcl interpreter use.
> 
> The registry.db is pretty huge:
> 
> $ ls -la
> total 1286264
> drwxr-xr-x     7 root  admin        238 21 Jun 11:06 .
> drwxr-xr-x@   15 root  admin        510 18 Dec  2018 ..
> -rw-r--r--     1 root  admin          0 21 Jun 10:59 .registry.lock
> -rw-rw-r--     1 root  admin          0  1 Oct  2015 .turd_MacPorts
> drwxr-xr-x  2954 root  admin     100436 21 Jun 10:59 portfiles
> drwxr-xr-x   185 root  admin       6290 13 Jun 19:51 portgroups
> -rw-r--r--     1 root  admin  658564096 21 Jun 11:06 registry.db
> 
> 
> As you can see, this install has been going along for 5 years, so I guess some bitrot could occur. I’m sure I could blow out the installation and start fresh, but that’s not terribly trivial on 10.5 PPC with no functional buildbot. 
> 
> Is there something else I can do to put that registry.db on a diet?
> 
> Thanks,
> 
> Ken