Re: [Sks-devel] Tuning

[Kristian Fiskerstrand]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

On 02/11/2014 08:19 PM, Daniel Kahn Gillmor wrote:
> On 02/11/2014 01:58 PM, Benny Baumann wrote:
>> Am 11.02.2014 16:59, schrieb Kristian Fiskerstrand:
>>> Unless you run it in a clustered setup where the different
>>> members calculate it on different times and the frontend passes
>>> the request on before timeout :p
>> 
>> Its almost instantly for my maschine ...
> 
> what is almost instantly, Benny?  Are you saying that the stats 
> calculation returns almost instantly?  If so, i wonder why there is
> such a variation.  How much RAM is available for your machine?
> what other contention do you have for disk I/O?  What kind of disks
> are you using?
> 
> On a pretty decent machine (zimmermann.mayfirst.org), i'm seeing
> the following duration in the logs:
> 
> 2014-02-11 19:17:17 Calculating DB stats 2014-02-11 19:17:49 Done
> calculating DB stats

Fwiw, I checked my db.log and the figures over the past few days are
on .33, a VM, 3GB RAM updating once a day:
Linux gentoo1 3.4.62-gentoo #1 SMP Fri Sep 20 01:27:24 CEST 2013
x86_64 Intel(R) Xeon(R) CPU E5620 @ 2.40GHz GenuineIntel GNU/Linux
2014-02-09 03:00:00 Calculating DB stats
2014-02-09 03:00:04 Done calculating DB stats
2014-02-10 03:00:00 Calculating DB stats
2014-02-10 03:00:13 Done calculating DB stats
2014-02-11 03:00:00 Calculating DB stats
2014-02-11 03:00:06 Done calculating DB stats

On .27, a VM. 2GB RAM, updating once an hour
Linux gentoo5 3.4.62-gentoo #1 SMP Fri Sep 20 01:27:24 CEST 2013
x86_64 Intel(R) Xeon(R) CPU E5620 @ 2.40GHz GenuineIntel GNU/Linux
2014-02-11 17:30:01 Calculating DB stats
2014-02-11 17:30:04 Done calculating DB stats
2014-02-11 18:30:01 Calculating DB stats
2014-02-11 18:30:04 Done calculating DB stats
2014-02-11 19:30:01 Calculating DB stats
2014-02-11 19:30:04 Done calculating DB stats

On .6, slightly older physical computer, 2GB RAM, updating once an hour
Linux gamma 3.4.62-gentookf1 #3 SMP Sun Nov 17 12:06:10 CET 2013
x86_64 Intel(R) Xeon(R) CPU 5110 @ 1.60GHz GenuineIntel GNU/Linux
2014-02-11 18:20:01 Calculating DB stats
2014-02-11 18:20:06 Done calculating DB stats
2014-02-11 19:20:01 Calculating DB stats
2014-02-11 19:20:05 Done calculating DB stats
2014-02-11 20:20:01 Calculating DB stats
2014-02-11 20:20:05 Done calculating DB stats

- -- 
- ----------------------------
Kristian Fiskerstrand
Blog: http://blog.sumptuouscapital.com
Twitter: @krifisk
- ----------------------------
Public PGP key 0xE3EDFAE3 at hkp://pool.sks-keyservers.net
fpr:94CB AFDD 3034 5109 5618 35AA 0B7F 8B60 E3ED FAE3
- ----------------------------
"Excellence is not a singular act but a habit. You are what you do
repeatedly."
(Shaquille O'Neal)
-----BEGIN PGP SIGNATURE-----

iQIcBAEBCgAGBQJS+npHAAoJEPw7F94F4TaggqUP/36dMuVCBhGxsGuKmnJnfRCr
LoCklIebttHyzuacphE/DsvHDEci2j5KGsTq3WzxaRnHomW9Lcz99qL2joXxAN26
rfNBmiGEEP3HZfct3jLn6rlO5dre3QgcGgacl35wQnuQq1oEC1r5nMgPsd+uf+DE
O/VB1oi/wkZsyGqLiEaC1DeKhxfK7+7hKfTAVqfWDoX7idSBpfV7hE8ny5Do7Hju
7RVoGza/A+6WSwWpAaQsxuQeAvt6gWjyS/bL5Ud1jlUgTTSf/u9odVsgNmaaStO7
9vWT4Iyts/SuYbzJlKuzbbAmN+ID1KfoePCX/+CTM6qw2PHoMjqqB3LvvngooEbo
fbGuWGhw/M3q33ruNV6RtONtnN4Qv9DQizWZPRomZxevqtzu1qicu9pHkGwoJgyT
N1MmlxKEneFxBTWEz7++i85uIVLmZKAwYIdUwLPwaXc91JGCbOaC6Kh/WitSAuUs
33ZqJXvl9UVLiShTKH84wCoesS8QNokvlt7XutMMfNzLIdATbd4zuottT9xIL+Vh
ky9/z1vg0mfc5pgnxAPkcMBewiuspKOCOLCPDESkNUBpCtdJ7dDh7aka/IFOVPyb
IuyoYdNzwSo0adBjJAYjyEX0ZJWspf22fFJuciM3qUktj3nIjERa8IFPG6cnL8qR
en67T8X2z/Cx0PD7m0go
=iFzI
-----END PGP SIGNATURE-----