Toot

Written by Hugo Mills on 2024-09-27 at 11:49

Badly written DB query in an app, causes the DB to collapse if one page is hit too often with the wrong parameters.

Some crawler gets stuck in that page, hitting it repeatedly.

for $m in management_list:

[summarise the situation to $m]

"So it's caused by the bot."

"No, it's caused by a badly written query. The bot just happens to hit it a lot."

"So we block the bot."

"We can do, but we need to fix the query."

I'm now on the second round of that loop...

=> More informations about this toot | View the thread | More toots from darkling@mstdn.social

Mentions

Tags

Proxy Information
Original URL
gemini://mastogem.picasoft.net/toot/113209363406759707
Status Code
Success (20)
Meta
text/gemini
Capsule Response Time
221.204297 milliseconds
Gemini-to-HTML Time
0.425939 milliseconds

This content has been proxied by September (3851b).