| speeding up zypp |
[Sep. 25th, 2007|05:03 pm] |
| [ | Current Location |
| | Home | ] |
| [ | mood |
| |  amused | ] |
| [ | music |
| | Random Playlist | ] |
On my Laptop, a 800Mhz P3 Mobile, 256MB RAM, ext3, the new updater has always been a bit slow.
After several beta upgrades I had it at RC1 level and tested online updates.
$ time zypper lu
real 3m4.187s
user 0m31.306s
sys 0m3.440s
Boringly long and it hits the disk constantly. Lets see the size of the zypp.db sqlite cache ... 80 MB (wtf? for the whole 10.3 repo + 2 times the update repo?)
Also the rpm database is 40MB for Packages, and another 10MB for the filelist (why?).
So what can we do:
Defragment on the disk
Due to repeated increase the file is fragmented on the disk. Not good for seek patterns.
The easiest way to fix this is to:
cp file file.new ; rm file ; mv file.new file
The full file copy defragments the file nearly by itself.
So doing this for the large zypp.db, Packages and the Filenames and Dirnames of /var/lib/rpm we
get:
$ time zypper lu
real 2m40.794s
user 0m31.242s
sys 0m3.400s
24 seconds saved.
Clean up the zypp.db cache
There is internal fragmentation in the zypp.db, partially caused by repos I had added and now
removed, partially due to refreshes.
So we run:
sqlite3 /var/cache/zypp/zypp.db vacuum
It is now 29 MB.
Alternatively you can also just rebuild it from scratch, which will give the same result
rm /var/cache/zypp/zypp.db ; zypper refresh
fragmentation of RPM Packages DB
The RPM DB also seems to get internally fragmented, the "reading packages" takes very long.
I tried rpm --rebuilddb.
Now the time is:
$ time zypper lu
real 2m2.523s
user 0m30.582s
sys 0m3.400s
And defragment it again (cp Packages Packages.new; rm Packages; mv Packages.new Packages)
$ time zypper lu
real 1m7.278s
user 0m32.730s
sys 0m3.160s
Just 2 minutes of 3 saved, and just a 200% speed up.
And SDBized: http://en.opensuse.org/SDB:Speed_up_Package_Manager_Stack |
|
|
![[info]](http://l-stat.livejournal.com/img/userinfo.gif){kind=small}
marcusmeissner's journal