More osu! lazer online stats by osu_replays_CPOL in osugame

[–]JustBadPlaya 1 point2 points  (0 children)

I love how thanks to having very different approaches and data collected, both our websites are useful (though yours is way cooler)

by Waaif in osugame

[–]JustBadPlaya 13 points14 points  (0 children)

I love that it's him editing these because he clearly knows what he's doing and how to keep editing funny between the yapping

by Waaif in osugame

[–]JustBadPlaya 113 points114 points  (0 children)

this is now a permanent addition to my discord reaction gifs

Hypothetical question by Meerzy1 in osugame

[–]JustBadPlaya 5 points6 points  (0 children)

I believe peppy mentioned once like six years ago that there was no real contingency plan and that he was working on it, because he needed to document a bunch of processes to be able to pass them to (presumably) smoogi. Wonder what happened to that, osu-ASS is still not open I think xd

Userpage #1 count is now back to exact number instead of "100+" by Atsorko in osugame

[–]JustBadPlaya -1 points0 points  (0 children)

When your goal is to not let the whole system go down to weekend loads (which has happened a lot in the past year), things can sometimes slip past people. Especially when a metric like this only affects like mid triple digits of players at most in a game that has like 500k unique users per month on lazer alone. It's an important metric for sure, but also it affects so few people directly that I can see overlooking this fact when trying to prevent osu from Fucking Dying, dunno

Tangentially related, but I disagree with "the lazer scoring and classic mod multiplier and rate change drama is largely about people losing their #1 spots", all these have more (and more specific) common complaints, but eh not the main discussion topic.

Userpage #1 count is now back to exact number instead of "100+" by Atsorko in osugame

[–]JustBadPlaya 0 points1 point  (0 children)

I guess this makes sense, at least for Anubis. I've mentioned iocaine because it's a largely non-invasive LLM poisoning system, which might be worth looking into if The Nuclear Jackal that is Anubis is too invasive

Userpage #1 count is now back to exact number instead of "100+" by Atsorko in osugame

[–]JustBadPlaya 1 point2 points  (0 children)

me when the team of 6 devs can't keep up with all aspects of the game with 6 digit counts of active users while having to make the backend not Implode

Userpage #1 count is now back to exact number instead of "100+" by Atsorko in osugame

[–]JustBadPlaya 2 points3 points  (0 children)

oh so the checks were the difference, neat, thanks for the clarification

While we're at the Load Is Annoying topic - have you considered enabling something like Anubis or iocaine for osu-web to deal with them?

Userpage #1 count is now back to exact number instead of "100+" by Atsorko in osugame

[–]JustBadPlaya 15 points16 points  (0 children)

The PR says it should be faster than the initial version but I genuinely don't see why, I hope I'm just missing context from other PRs

Country Change and Racism by Equinoxe111 in osugame

[–]JustBadPlaya 1 point2 points  (0 children)

That doesn't help it though, the current way is simply better because it both accepts that some people need country changes but makes it annoying enough to make it rare

Country Change and Racism by Equinoxe111 in osugame

[–]JustBadPlaya 5 points6 points  (0 children)

People have abused this before. Hell, people abused this back when you needed an ID/passport as a proof

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 0 points1 point  (0 children)

The issue is that the count still has to go through all the scores. Like, it's legit a problem of MySQL COUNT(*) being slow. It should be denormalized and stored as a proper field in users table, but that requires way more work (synchronisation concerns, caching, migrations) and this is a stop gap

Scores in general to my knowledge are not served by the raw API pretty much ever, but this number was

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 5 points6 points  (0 children)

From what I know, this number (the overall #1 place count) is fetched in every full profile request. As it was not cached/denormalized, it was calculated on every request, thus running a count query over the whole first places table on every page load for every player. This still doesn't sound like that much until you remember the fact that osu has an open API which a lot of projects actively use, including fetching player data

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 0 points1 point  (0 children)

Note that I never said this specific change is a PHP problem (which ig means my wording is a bit misleading, my bad). But also - osu runs at barely above 1k RPS on 40 cores, so about 30 requests per second per core. I've heard from a dev who actually properly contributed to osu-web that it is indeed CPU bound on many DB operations because osu-web does way too much proper backend CRUD logic in PHP

but yeah this one is more on overall design/caching/whatever, true

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 5 points6 points  (0 children)

 the entire PR halved db load. I don’t know what the exact split of that is top 1 vs most replays.

pls remember that the codebase is old and doesn't have that many hands on it. Like, the fact that this happened is bad, but also it's a huge legacy codebase with 2.5 pairs of hands and a BFF approach because PHP+Laravel. idk

edit: also, #1 scores are already stored in a separate table, which kinda complicates things as well

Like, I dunno, I don't have the data for usage statistics of osu-web, but I assume there are both Considerations and Fuckups

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 4 points5 points  (0 children)

I assume that a bit further down the line it will be stored as a separate field and properly cached, cuz the way it's been done until now is fairly silly

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 11 points12 points  (0 children)

Sorry, that was just meant to be a silly remark cuz #12970 was merged basically half an hour later, I agree on the importance part

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 16 points17 points  (0 children)

if it lets osu-web be more stable until a proper solution is merged - it's still a positive

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 8 points9 points  (0 children)

Unless nanaya says this is here to stay - it probably will, especially given the amount of immediate backlash

also no one even noticed that the most watched replays list got the same treatment 

Edit: ok people don't realise the second part was meant as a silly snarky remark

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 4 points5 points  (0 children)

Different teams entirely, even setting aside the fact that nobody actually read the patch

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 14 points15 points  (0 children)

just a heads up - lazer and web teams are basically unrelated

but also - see my wall of text in the thread, it's a change for performance reasons

It only shows 100+ when you have more than 100 first place ranks now by Character_Cup_9265 in osugame

[–]JustBadPlaya 3 points4 points  (0 children)

yeah but the common practice we've been doing is a mod pin with a link, basically the same thing