On Wed, Sep 17, 2014 at 1:58 PM, Bernhard Voelker <mail@bernhard-voelker.de> wrote:
On 09/17/2014 05:57 PM, Claudio Freire wrote:
Or [...]
... has someone checked what's the difference to other distros? {open,}SUSE seems to be the only one to be hit by this issue.
Comparing with an amazon linux: openSUSE: ~> /usr/lib/rpm/rpmdb_stat -d /var/lib/rpm/Packages Wed Sep 17 14:58:57 2014 Local time 61561 Hash magic number 9 Hash version number Little-endian Byte order Flags 52787 Number of pages in the database 4096 Underlying database page size 0 Specified fill factor 4030 Number of keys in the database 4030 Number of data items in the database 24 Number of hash buckets 23200 Number of bytes free on bucket pages (76% ff) 52311 Number of overflow pages 8141662 Number of bytes free in overflow pages (96% ff) 8 Number of bucket overflow pages 22417 Number of bytes free in bucket overflow pages (31% ff) 0 Number of duplicate pages 0 Number of bytes free in duplicate pages (0% ff) 435 Number of pages on the free list ~> time rpm -qa | wc -l 4029 real 0m1.173s user 0m1.048s sys 0m0.145s ~> echo 3 | sudo tee /proc/sys/vm/drop_caches 3 ~> time rpm -qa | wc -l 4029 real 0m31.426s user 0m1.522s sys 0m1.019s Amazon Linux: $ /usr/lib/rpm/rpmdb_stat -d /var/lib/rpm/Packages Wed Sep 17 17:58:37 2014 Local time 61561 Hash magic number 9 Hash version number Little-endian Byte order Flags 8920 Number of pages in the database 4096 Underlying database page size 0 Specified fill factor 508 Number of keys in the database 508 Number of data items in the database 3 Number of hash buckets 2977 Number of bytes free on bucket pages (75% ff) 6161 Number of overflow pages 1056910 Number of bytes free in overflow pages (95% ff) 1 Number of bucket overflow pages 2642 Number of bytes free in bucket overflow pages (35% ff) 0 Number of duplicate pages 0 Number of bytes free in duplicate pages (0% ff) 2753 Number of pages on the free list [ec2-user@ip-10-146-204-60 ~]$ echo 3 | sudo tee /proc/sys/vm/drop_caches 3 $ time rpm -qa | wc -l 507 real 0m3.306s user 0m0.304s sys 0m0.076s $ time rpm -qa | wc -l 507 real 0m0.258s user 0m0.232s sys 0m0.020s The Amazon Linux server has the same issue, but not nearly as bad, because the database is considerably smaller (and the I/O subsystem considerably better) -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org