[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

UDD migrated to ullmann, update your scripts! (Was: UDD migration to ullmann.debian.org)

TL;DR: The UDD (Ultimate Debian Database) migration to
ullmann.debian.org is finished. Please update your scripts to connect to
the new instance. See http://wiki.debian.org/UltimateDebianDatabase for
up-to-date information on how to connect.

Some details below:

On 25/06/12 at 09:54 +0200, Lucas Nussbaum wrote:
> [dsa] tune PG (with pgtune?)
>   Benchmark 1: (squeeze-security import)
>   udd@ullmann:/srv/udd.debian.org/udd$ time ./update-and-run.sh debian-squeeze-security
>   ullmann: real	0m55.363s user	0m10.285s sys	0m0.476s
>   my laptop (with SSD): real	0m17.079s user	0m9.229s sys	0m0.196s
>   samosa: real	9m48.011s user	0m26.834s sys	0m1.116s
>   Benchmark 2: (bugs import)
>   udd@ullmann:/srv/udd.debian.org/udd$ time ./update-and-run.sh bugs
>   ullmann: real	33m12.664s user	26m44.580s sys	1m31.834s
>   my laptop (with SSD): real	17m37.500s user	16m4.344s sys	0m25.270s
>   samosa: hours
>   (the numbers for samosa are particularly bad, but that could be because 
>   the cron'ed manual vacuuming happens at the beginning of each month)

So, this was tracked down to slightly-lower-than-expected I/O
performance on ullmann, due to one or several of the various layers over
the SSD (DRBD, virtio, LVM, ...).

> [tille] ddtp, ubuntu-ddtp ftpnew screenshots, bibref, blends-prospective,
>    removals, i18n-apps
>    please integrate the needed tables into sql/setup.sql, I got lost in all 
>    your .sql files and moved them to sql/Attic/
>    those importers are disabled in cron currently

This has not been done yet.

All scripts hosted on http://udd.debian.org/ have been updated to use
the new instance.

Thanks a lot for everybody involved in this.


Reply to: