HackerTrans
TopNewTrendsCommentsPastAskShowJobs

Mojah

3,168 karmajoined 17 anni fa

Submissions

What alerting on 1.8M outages has thought us about downtime

ohdear.app
5 points·by Mojah·5 giorni fa·2 comments

Transcribing my old podcast locally with open-source AI

ma.ttias.be
2 points·by Mojah·28 giorni fa·1 comments

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

ohdear.app
19 points·by Mojah·29 giorni fa·8 comments

AI Is a Confidence Booster

ma.ttias.be
2 points·by Mojah·mese scorso·0 comments

More Time to Think

ma.ttias.be
5 points·by Mojah·mese scorso·0 comments

Postcards from Around the World

kaartje.earth
1 points·by Mojah·3 mesi fa·0 comments

A 3-part series on SQL performance optimisations

ohdear.app
2 points·by Mojah·6 mesi fa·0 comments

Using AI is no longer optional

ma.ttias.be
1 points·by Mojah·6 mesi fa·0 comments

Using AI is no longer optional

ma.ttias.be
1 points·by Mojah·6 mesi fa·1 comments

Web development is fun again

ma.ttias.be
487 points·by Mojah·6 mesi fa·627 comments

SQL performance improvements: analysing and fixing the slow queries

ohdear.app
1 points·by Mojah·9 mesi fa·0 comments

comments

Mojah
·5 giorni fa·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 mesi fa·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 mesi fa·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 mesi fa·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 mesi fa·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 mesi fa·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 mesi fa·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.