ruaok: I guess I'm worried about overloading PG if something goes wrong, but we could try it
2021-10-01 27401, 2021
bitmap
how much is a lot? :) I was thinking 500 -> 600 initially
2021-10-01 27423, 2021
ruaok
well, is the hardware near breaking right now?
2021-10-01 27435, 2021
ruaok
which one is the primary right now? floyd?
2021-10-01 27441, 2021
ruaok
floyd's max load is at 4 per day.
2021-10-01 27459, 2021
bitmap
yes, floyd
2021-10-01 27426, 2021
ruaok looks for the IO stats
2021-10-01 27430, 2021
ruaok
I cant find one, but friday afternoon, one of our busier times and read/write on floyd is in the hundreds of Ks.
2021-10-01 27438, 2021
ruaok
uhm, double it?
2021-10-01 27441, 2021
ruaok
1000?
2021-10-01 27409, 2021
bitmap
looking at the stats we can probably double it. it's only a theoretical maximum anyway
2021-10-01 27414, 2021
bitmap
let's try 1000 then
2021-10-01 27438, 2021
ruaok
if we find that floyd is struggling, lets back off. but floyd is bored right now.
2021-10-01 27410, 2021
agatzk has quit
2021-10-01 27456, 2021
agatzk joined the channel
2021-10-01 27423, 2021
bitmap
okay, it's set & applied to 1000 now
2021-10-01 27442, 2021
ruaok
great, lets watch the sparks fly. :(
2021-10-01 27406, 2021
bitmap
😰
2021-10-01 27412, 2021
dgw has quit
2021-10-01 27417, 2021
dgw joined the channel
2021-10-01 27448, 2021
bitmap
I'm still wondering where 500 client connections are coming from...right now we have around 70. no good stats for this though. I might have to write a script that dumps 'show clients;' every 10 seconds or so and collects stats on where the connections are coming from
2021-10-01 27428, 2021
ruaok
well, consider that LB uses the MB DB directly. So does CB and soon AB.
2021-10-01 27404, 2021
ruaok
and soon LB will add more "info about the music" type stuff that will also need more traffic.
2021-10-01 27425, 2021
ruaok
oh, and did you see that the riksucks is working on the "you data missing from MB" feature?
2021-10-01 27431, 2021
ruaok
*your
2021-10-01 27402, 2021
ruaok
we're trying to convert some LB users to add more data to MB.
2021-10-01 27433, 2021
bitmap
does LB connect to MB in bursts (for the stats it collects that you mentioned before)?
2021-10-01 27441, 2021
bitmap
oh yeah, I saw talk about that. that'll be sweet
2021-10-01 27427, 2021
ruaok
not that I can think off right now -- the burst type lookups are pointed at the sitemaps MB mirror.
2021-10-01 27419, 2021
ruaok
the MBID mapping does do direct MB lookups. not sure about its burstiness.
2021-10-01 27427, 2021
bitmap
hmm okay. I didn't think LB alone would make us jump from 70 -> 500 client connections
2021-10-01 27442, 2021
ruaok
that is unlikely, yes
2021-10-01 27458, 2021
ruaok
but zas also mentioned earlier that there was a lot more traffic.
