HackerTrans
TopNewTrendsCommentsPastAskShowJobs

Mojah

3,168 karmajoined 17년 전

Submissions

What alerting on 1.8M outages has thought us about downtime

ohdear.app
5 points·by Mojah·5일 전·2 comments

Transcribing my old podcast locally with open-source AI

ma.ttias.be
2 points·by Mojah·28일 전·1 comments

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

ohdear.app
19 points·by Mojah·29일 전·8 comments

AI Is a Confidence Booster

ma.ttias.be
2 points·by Mojah·지난달·0 comments

More Time to Think

ma.ttias.be
5 points·by Mojah·지난달·0 comments

Postcards from Around the World

kaartje.earth
1 points·by Mojah·3개월 전·0 comments

A 3-part series on SQL performance optimisations

ohdear.app
2 points·by Mojah·6개월 전·0 comments

Using AI is no longer optional

ma.ttias.be
1 points·by Mojah·6개월 전·0 comments

Using AI is no longer optional

ma.ttias.be
1 points·by Mojah·6개월 전·1 comments

Web development is fun again

ma.ttias.be
487 points·by Mojah·6개월 전·627 comments

SQL performance improvements: analysing and fixing the slow queries

ohdear.app
1 points·by Mojah·9개월 전·0 comments

comments

Mojah
·5일 전·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
·6개월 전·discuss
We’ve been seeing a surprising amount of leads come through this site, clearly the demand for a EU alternative is high.
Mojah
·8개월 전·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
·8개월 전·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
·8개월 전·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
·10개월 전·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
·10개월 전·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.