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.