I thought it was because it's joint by another artist as well, but upon a closer look, https://musicbrainz.org/release-group/7a2bb171-... *is* included and that's a joint artist work too... Is there any other reason that EP might be excluded from the results?
alastairp
ZoeB: there are only 25 results there, but 31 in total
ZoeB
(I can see an argument that I *may* have over-engineered my website to be reliant upon this...)
I note that you're also doing a query for release-groups, but you're saying that a release isn't in the results
was that an error?
ruaok
AB is back. the work_mem doesn't seem to be reducing the temp files. let me let it settle down for a bit.
zas
ruaok: what's the size of the ab database ?
ruaok
waaaay bigger than reo's mum.
zas
i mean in megabytes ? does it fit in ram or not ?
ruaok
no.
ZoeB
I'm somewhat manually recursing, pulling in "http://musicbrainz.org/ws/2/release? release-group={$releaseGroupID}&inc=recordings+artist-credits+url- rels&fmt=json" for each result. I only had https://wiki.musicbrainz.org/Development/JSON_W... to go on, so a bit of trial and error was involved. It's not my best work, I'll be honest... (;-.-)
right, that's fine. I just wasn't sure if you were doing that step when you said "it's not there"
ruaok
that is the largest file on disk.
Mr_Monkey
iliekcomputers: I can't seem to request your review from the PR page, so here I am: I fixed the issues I was having, but would love another pair of eyes to look at https://github.com/bookbrainz/bookbrainz-site/p...
ruaok
close to 600GB in total
ZoeB
Ah, that fixed it, thank you so much!
alastairp
ZoeB: you can also do /release?artist={artist-id} if that helps? if you get 100 items at a time it might be less queries than doing 1 for every release-group-id?
what was the highest value you tried for work_mem ?
ruaok
the current of 128MB
chhavi_ joined the channel
zas
try 512M, just to see if it has any effect, i think queries and/or indexes just need huge optimization, especially if tables/db are big
ruaok
first I want to see the effect of more shared buffers.
zas
the traffic isn't that high, we could set up telegraf to collect frank's pg stats as we do for bowie, but it needs some config on pg side, we may do that tomorrow
just to see how many transactions etc...
yvanzo
ruaok: I just checked the Alpine CVE, Solr doesn’t rely on system authentification, thus mb-solr is not affected.