HackerTrans
TopNewTrendsCommentsPastAskShowJobs

Mojah

3,168 karmajoined vor 17 Jahren

Submissions

What alerting on 1.8M outages has thought us about downtime

ohdear.app
5 points·by Mojah·vor 5 Tagen·2 comments

Transcribing my old podcast locally with open-source AI

ma.ttias.be
2 points·by Mojah·vor 28 Tagen·1 comments

The ghost domain problem in DNS, and what we're doing about it

ohdear.app
19 points·by Mojah·vor 29 Tagen·8 comments

AI Is a Confidence Booster

ma.ttias.be
2 points·by Mojah·letzten Monat·0 comments

More Time to Think

ma.ttias.be
5 points·by Mojah·letzten Monat·0 comments

Postcards from Around the World

kaartje.earth
1 points·by Mojah·vor 3 Monaten·0 comments

A 3-part series on SQL performance optimisations

ohdear.app
2 points·by Mojah·vor 6 Monaten·0 comments

Using AI is no longer optional

ma.ttias.be
1 points·by Mojah·vor 6 Monaten·0 comments

Using AI is no longer optional

ma.ttias.be
1 points·by Mojah·vor 6 Monaten·1 comments

Web development is fun again

ma.ttias.be
487 points·by Mojah·vor 6 Monaten·627 comments

SQL performance improvements: analysing and fixing the slow queries

ohdear.app
1 points·by Mojah·vor 9 Monaten·0 comments

comments

Mojah
·vor 5 Tagen·discuss
Indeed, surprised me too - the majority of that is made up of "death by a thousand paper cuts", many 1 or 2 minute outages.
Mojah
·vor 6 Monaten·discuss
We’ve been seeing a surprising amount of leads come through this site, clearly the demand for a EU alternative is high.
Mojah
·vor 8 Monaten·discuss
Co-founder here, we'll be working on better ways to handle this over the coming days.

Update: our app is available again without Cloudflare, you'll be able to post updates to status pages smoothly again.
Mojah
·vor 8 Monaten·discuss
Interestingly, also noticing that websites that use Cloudflare Challenge (aka "I'm not a Robot") are also throwing exceptions with a message as "Please unblock challenges.cloudflare.com to proceed" - even though it's just responding with an HTTP/500.
Mojah
·vor 8 Monaten·discuss
Most companies prefer to fix any downtime before it's noticed, and sharing any details on a status page means admitting something went wrong.

There's plenty of status page solutions that tie in uptime monitoring with status updates, essentially providing a "if we get an alert, anyone can follow along through the status page" for near real-time updates. But, it means showing _all_ users that something went wrong, when maybe only a handful noticed it in the first place.

It's a flawed tactic to try and hide/dismiss any downtime (people will notice), but it's in our human nature to try and hide the bad things?

[1] ie https://ohdear.app/features/status-pages
Mojah
·vor 10 Monaten·discuss
Have you been able to try this with a `SELECT SQL_NO_CACHE * FROM ...` query?

If it's for local testing, you could try to cripple InnoDB as much as possible by just setting some absurdly low values, that would almost certainly mean no InnoDB caching is happening; https://gist.github.com/mattiasgeniar/87cd4a10bfcc788d81b51f...
Mojah
·vor 10 Monaten·discuss
Totally depends on the use case I suppose, we found that in our environment, we perform _a lot_ more SELECT's than we do UPDATE/DELETE/INSERT's.

And with some badly optimized SELECT's, the time MySQL had to spend on sorting results/reading from disk in an inefficient way made all our _write_ queries suffer.

By optimizing our SELECTs first, we freed up some CPU bandwidth (it seems?) that can be spent doing all the other work.