HackerTrans
トップ新着トレンドコメント過去質問紹介求人

Mojah

3,168 カルマ登録 17 年前

投稿

What alerting on 1.8M outages has thought us about downtime

ohdear.app
5 ポイント·投稿者 Mojah·5 日前·2 コメント

Transcribing my old podcast locally with open-source AI

ma.ttias.be
2 ポイント·投稿者 Mojah·28 日前·1 コメント

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

ohdear.app
19 ポイント·投稿者 Mojah·29 日前·8 コメント

AI Is a Confidence Booster

ma.ttias.be
2 ポイント·投稿者 Mojah·先月·0 コメント

More Time to Think

ma.ttias.be
5 ポイント·投稿者 Mojah·先月·0 コメント

Postcards from Around the World

kaartje.earth
1 ポイント·投稿者 Mojah·3 か月前·0 コメント

A 3-part series on SQL performance optimisations

ohdear.app
2 ポイント·投稿者 Mojah·6 か月前·0 コメント

Using AI is no longer optional

ma.ttias.be
1 ポイント·投稿者 Mojah·6 か月前·0 コメント

Using AI is no longer optional

ma.ttias.be
1 ポイント·投稿者 Mojah·6 か月前·1 コメント

Web development is fun again

ma.ttias.be
487 ポイント·投稿者 Mojah·6 か月前·627 コメント

SQL performance improvements: analysing and fixing the slow queries

ohdear.app
1 ポイント·投稿者 Mojah·9 か月前·0 コメント

コメント

Mojah
·5 日前·議論
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 か月前·議論
We’ve been seeing a surprising amount of leads come through this site, clearly the demand for a EU alternative is high.
Mojah
·8 か月前·議論
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 か月前·議論
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 か月前·議論
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 か月前·議論
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 か月前·議論
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.