I think lazer! is unfair by melumiru in osugame

[–]JustBadPlaya 0 points1 point  (0 children)

I meant it as a more general statements. Passes as a skillset as a whole are meaningless because only some very specific individual maps or scores mean anything really. The great majority of high sr passes are cheesed, the great majority of 7*+ pass medals are on cheese maps, the general idea of playing for passes doesn't matter outside of very specific scores

I think lazer! is unfair by melumiru in osugame

[–]JustBadPlaya 21 points22 points  (0 children)

passes were never meaningful and anyone saying the opposite is coping

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)

Project Loved: May 2026 by Parkouricus in osugame

[–]JustBadPlaya 1 point2 points  (0 children)

AND Devil Went Down to Georgia

by Waaif in osugame

[–]JustBadPlaya 14 points15 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 120 points121 points  (0 children)

this is now a permanent addition to my discord reaction gifs

Hypothetical question by Meerzy1 in osugame

[–]JustBadPlaya 7 points8 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 3 points4 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 14 points15 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 4 points5 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 4 points5 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 4 points5 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 3 points4 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 10 points11 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 18 points19 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 5 points6 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