-
ruaok
come back.
2014-01-06 00616, 2014
-
ruaok
changes two things at once. :(
2014-01-06 00625, 2014
-
ruaok
I'll test balloon this one small table.
2014-01-06 00634, 2014
-
ocharles
have you tried just restarting totoro at all, out of interest?
2014-01-06 00642, 2014
-
ruaok
not totoro.
2014-01-06 00644, 2014
-
ruaok
pg, yes.
2014-01-06 00647, 2014
-
ruaok
no change
2014-01-06 00649, 2014
-
ocharles
ok
2014-01-06 00650, 2014
-
uk joined the channel
2014-01-06 00659, 2014
-
ruaok
label table reindexed.
2014-01-06 00607, 2014
-
ruaok
that was nice and fast and indeed locked everything.
2014-01-06 00624, 2014
-
ruaok
I rather doubt its the indexes.
2014-01-06 00630, 2014
-
ruaok
I think I would prefer to up shared_buffers
2014-01-06 00651, 2014
-
ocharles
yea, I'd put more weight on that
2014-01-06 00658, 2014
-
ocharles
To change that, you should change things in server-configs
2014-01-06 00621, 2014
-
ruaok
I suspect it would be faster if you did that, rather than me learning that now.
2014-01-06 00626, 2014
-
ocharles
ok
2014-01-06 00627, 2014
-
ocharles
ruaok: so you want to go to 10GB?
2014-01-06 00639, 2014
-
ruaok
yeah. thoughts?
2014-01-06 00647, 2014
-
ocharles
it's not much further from where you are
2014-01-06 00654, 2014
-
ocharles
May be better to try 12
2014-01-06 00601, 2014
-
ruaok
thats 50%
2014-01-06 00615, 2014
-
ruaok
if there are detrimental effects we're likely to hit them at 50%
2014-01-06 00622, 2014
-
misterswag joined the channel
2014-01-06 00626, 2014
-
ocharles
ok, we'll try 10 then
2014-01-06 00600, 2014
-
ruaok
shall I tweet about a quick downtime?
2014-01-06 00605, 2014
-
ocharles
sure
2014-01-06 00618, 2014
-
ocharles
I don't really have time to do a proper downtime release tohugh...
2014-01-06 00647, 2014
-
ruaok
how long does it take?
2014-01-06 00608, 2014
-
ocharles
If you ./provision.sh on totoro, you'll pull in new sysctl settings and higher shared_buffers
2014-01-06 00610, 2014
-
ruaok
I'm just thinking setting the whole site to 503.
2014-01-06 00621, 2014
-
alastairp
JonnyJD_: around?
2014-01-06 00625, 2014
-
alastairp
ianmcorvidae: too
2014-01-06 00627, 2014
-
ocharles
that would be easier, yea
2014-01-06 00637, 2014
-
ruaok
and then do the provision, and then restart.
2014-01-06 00648, 2014
-
ruaok
I tweet & drive proxy, you provision?
2014-01-06 00602, 2014
-
ocharles
sounds good
2014-01-06 00650, 2014
-
ruaok
twatted.
2014-01-06 00658, 2014
-
ocharles
ruaok: ok, well I'm ready to try and provision again
2014-01-06 00604, 2014
-
ruaok
ok, me too.
2014-01-06 00605, 2014
-
ruaok
hang on.
2014-01-06 00612, 2014
-
ocharles
k, just shout when
2014-01-06 00628, 2014
-
ruaok
feh, still up.
2014-01-06 00651, 2014
-
ruaok
ok, site down.
2014-01-06 00652, 2014
-
ruaok
go
2014-01-06 00649, 2014
-
ocharles watches
2014-01-06 00657, 2014
-
ruaok
good job us.
2014-01-06 00602, 2014
-
ruaok
we started right on top of the hour. :(
2014-01-06 00609, 2014
-
ruaok
and didn't turn off cron on astro.
2014-01-06 00613, 2014
-
ocharles
ruaok: it's back up with 10GB
2014-01-06 00617, 2014
-
ocharles
good timing.
2014-01-06 00634, 2014
-
ocharles
we had enough sysctl settings for 10gb without a reboot
2014-01-06 00642, 2014
-
ruaok
should be coming back up now.
2014-01-06 00621, 2014
-
ruaok
both main and beta are 502ing.
2014-01-06 00626, 2014
-
ruaok
come totoro, read faster!
2014-01-06 00628, 2014
-
Jozo
Is toroto main db? How much memory it has?
2014-01-06 00640, 2014
-
ocharles
24GB, I think
2014-01-06 00644, 2014
-
ocharles
and yea, it's the main database
2014-01-06 00644, 2014
-
ruaok
yep
2014-01-06 00606, 2014
-
ruaok
beta is back.
2014-01-06 00639, 2014
-
ruaok
ok, site is responding normally now.
2014-01-06 00621, 2014
-
ocharles
that was snappy
2014-01-06 00635, 2014
-
reosarevok
2014-01-06 00641, 2014
-
reosarevok
(or at least taking ages to load)
2014-01-06 00641, 2014
-
ruaok
disk hasn't calmed down yet.
2014-01-06 00647, 2014
-
Jozo
What I calculated indexes need over 20GB. (Someone can verify that)
2014-01-06 00618, 2014
-
reosarevok
Yeah, still 504
2014-01-06 00624, 2014
-
reosarevok sulks
2014-01-06 00650, 2014
-
ruaok
stuck proc killer restarted.
2014-01-06 00653, 2014
-
ruaok
load much better.
2014-01-06 00604, 2014
-
ruaok
but, effectively nothing has changed. :(
2014-01-06 00633, 2014
-
ocharles
I may be able to do a better job tonight when I'm not trying to do two jobs concurrently
2014-01-06 00646, 2014
-
ruaok
ok, thanks for your time now.
2014-01-06 00648, 2014
-
ocharles
but I have a (different) meeting at 8pm
2014-01-06 00653, 2014
-
ocharles
I'll keep fiddling until I leave the office
2014-01-06 00657, 2014
-
ocharles
But I'm not sure what to suggets :(
2014-01-06 00603, 2014
-
ruaok
I'd love for you to pop back in later when Ian is here.
2014-01-06 00604, 2014
-
ocharles
the fact the timeouts aren't working is something that should be investigated
2014-01-06 00609, 2014
-
ocharles
because they do work in the psql shell
2014-01-06 00612, 2014
-
ruaok
for sure.
2014-01-06 00619, 2014
-
ocharles
so I wonder if musicbrainz-server is actually setting them correctly
2014-01-06 00632, 2014
-
ocharles
that would at least remove the need for your stuck process killer
2014-01-06 00641, 2014
-
ruaok
agreed.
2014-01-06 00649, 2014
-
ruaok
well, we've ruled out a few things.
2014-01-06 00659, 2014
-
ruaok
I'l keep my eye on things and see how things progress.
2014-01-06 00650, 2014
-
CallerNo6 joined the channel
2014-01-06 00633, 2014
-
JonnyJD_
alastairp: around
2014-01-06 00648, 2014
-
alastairp
cool. pushing a release out now
2014-01-06 00632, 2014
-
JonnyJD_
alastairp: did you have a look at the outstanding PRs?
2014-01-06 00654, 2014
-
JonnyJD_
there are 2 I think that mainly need review / your decision
2014-01-06 00655, 2014
-
alastairp
not yet. just verifying the changelog now, then I'll do that
2014-01-06 00606, 2014
-
alastairp
ok
2014-01-06 00630, 2014
-
alastairp
105 & 135?
2014-01-06 00602, 2014
-
JonnyJD_
alastairp: yes
2014-01-06 00626, 2014
-
Jozo
2014-01-06 00621, 2014
-
Jozo
Is all indexes over 24GB?
2014-01-06 00616, 2014
-
adhawkins
ocharles: Presume you saw this: :)
2014-01-06 00620, 2014
-
adhawkins
2014-01-06 00641, 2014
-
Jozo
I have some musicbrainz-database git checkout... And I'm not aplle compile it (yet)...
2014-01-06 00639, 2014
-
kepstin-laptop is glad he got a thinkpad before they managed to introduce this abomination: http://www.youtube.com/watch?v=zT8pPS0JPrQ :/
2014-01-06 00614, 2014
-
reosarevok
kepstin-laptop: did you get the one with the weird trackpad?
2014-01-06 00623, 2014
-
misterswag joined the channel
2014-01-06 00636, 2014
-
kepstin-laptop
yes, but that's actually usable with software tweaks.
2014-01-06 00605, 2014
-
reosarevok
Yeah, I mean, I'm thinking of a T540p and wondering how weird/annoying that is
2014-01-06 00614, 2014
-
kepstin-laptop
it's actually worse in windows than linux, because you lose the middle button in windows
2014-01-06 00632, 2014
-
kepstin-laptop
(it's permanently set to 'scroll', and doesn't send a middle click event)
2014-01-06 00638, 2014
-
alastairp
kepstin-laptop: so much opportunity for hacking!
2014-01-06 00651, 2014
-
reosarevok never uses a middle button, so not a problem
2014-01-06 00606, 2014
-
kepstin-laptop uses it *all the time* to open stuff in tabs
2014-01-06 00610, 2014
-
kepstin-laptop
and paste, on linux
2014-01-06 00626, 2014
-
reosarevok
I use ctrl+click since my lappy doesn't have a middle button
2014-01-06 00649, 2014
-
reosarevok
alastairp: what, do you want to display "if u read this ur dumb" in there instead of the keys? :p
2014-01-06 00656, 2014
-
alastairp
:D
2014-01-06 00604, 2014
-
kepstin-laptop
it looks like it's kind of neat - a touch-sensitive oled screen
2014-01-06 00619, 2014
-
kepstin-laptop
but they could have had that in addition to some real buttons rather than instead of them :/
2014-01-06 00641, 2014
-
reosarevok
kepstin-laptop: my main worry is that the whole "all pad goes down" thing will feel too awkward
2014-01-06 00602, 2014
-
reosarevok
(it seems noisy but well, I'm way too noisy with the keyboard already anyway :p)
2014-01-06 00605, 2014
-
kepstin-laptop
reosarevok: it's not that bad.
2014-01-06 00617, 2014
-
kepstin-laptop
if you click on the top, only the top seems to go down.
2014-01-06 00624, 2014
-
kepstin-laptop
has almost 1mm of travel
2014-01-06 00628, 2014
-
reosarevok
And on the bottom?
2014-01-06 00632, 2014
-
Jozo has left the channel
2014-01-06 00637, 2014
-
kepstin-laptop
why would you ever click on the bottom?
2014-01-06 00645, 2014
-
kepstin-laptop
there's a trackpoint you could be using.
2014-01-06 00653, 2014
-
reosarevok
Wel, I've never used a trackpoint, so that's where I'm used to click
2014-01-06 00659, 2014
-
reosarevok
So at least until I get used to it...
2014-01-06 00613, 2014
-
hawke joined the channel
2014-01-06 00622, 2014
-
reosarevok
(tbh having my finger in that tiny red thing feels really weird, although I should try it out more)
2014-01-06 00632, 2014
-
kepstin-laptop
if you click on the bottom, only the bottom seems to go town (the trackpoint kind of tilts)
2014-01-06 00637, 2014
-
uk joined the channel
2014-01-06 00642, 2014
-
reosarevok
Good :)
2014-01-06 00646, 2014
-
kepstin-laptop
if you click in the middle, the entire thing goes down
2014-01-06 00603, 2014
-
reosarevok
Now *that* is something I don't know why anyone would ever do :D
2014-01-06 00608, 2014
-
kepstin-laptop
(you can left-click by pushing down anywhere on the pad)
2014-01-06 00653, 2014
-
reosarevok
Well, I guess I should ask to use my friend's old thinkpad for a bit to see if I can get used to the trackpoint :)
2014-01-06 00602, 2014
-
kepstin-laptop
the linux multitouch doesn't work properly for clicking and dragging with one finger on a button area, the other moving
2014-01-06 00611, 2014
-
kepstin-laptop
that's a driver bug tho, the pad supports 5-finger tracking fully.
2014-01-06 00623, 2014
-
reosarevok
Hmm. So it'll probably get fixed
2014-01-06 00624, 2014
-
reosarevok
Good
2014-01-06 00657, 2014
-
kepstin-laptop
(it works sometimes, but it's annoyingly inconsistant)
2014-01-06 00603, 2014
-
kepstin-laptop
seems to depend which order you put fingers on the pad :/
2014-01-06 00626, 2014
-
kepstin-laptop
usually ends up just making you multitouch scroll instead :/
2014-01-06 00640, 2014
-
uk has registered nick chirlu` and will use that henceforth.
2014-01-06 00643, 2014
-
reosarevok
Can't you deactivate the scroll?
2014-01-06 00654, 2014
-
kepstin-laptop
yes, but then scrolling sucks.
2014-01-06 00659, 2014
-
ocharles
adhawkins: yea :)
2014-01-06 00604, 2014
-
reosarevok really doesn't like trackpad scrolling anyway, that's what pgup/pgdn are for
2014-01-06 00616, 2014
-
kepstin-laptop
the only thing I use the touchpad for is for the trackpoint buttons and scroll gesture.
2014-01-06 00622, 2014
-
reosarevok
Ok, I *think* I can live with that then :)
2014-01-06 00635, 2014
-
reosarevok
(if not I bet I can re-sell it to some European who wants it anyway :p)
