Waldo Jaquith on Nostr: If your MariaDB / MySQL server is overwhelmed by connections, consider the ...
If your MariaDB / MySQL server is overwhelmed by connections, consider the possibility that that they default to retaining sleeping connections for *eight hours* and you might want to go ahead and set wait_timeout to like, five minutes or something.
Published at
2024-11-19 15:10:15Event JSON
{
"id": "62bf0bcf7d30373d15b9dad5c8e73cebb11870315141816954ac25cf61747baa",
"pubkey": "6479c0da48c8d33f04862daca0e5e76d5c49820a091f5eb02fb27903137074fc",
"created_at": 1732029015,
"kind": 1,
"tags": [
[
"imeta",
"url https://files.mastodon.social/media_attachments/files/113/510/253/309/575/753/original/993557ea4a718515.png",
"m image/png",
"dim 942x612",
"blurhash U9Ss89NHV@-;~VIVIUkC9Fs8s.Wr-;IoM{xa"
],
[
"proxy",
"https://mastodon.social/users/waldoj/statuses/113510253585914177",
"activitypub"
]
],
"content": "If your MariaDB / MySQL server is overwhelmed by connections, consider the possibility that that they default to retaining sleeping connections for *eight hours* and you might want to go ahead and set wait_timeout to like, five minutes or something.\n\nhttps://files.mastodon.social/media_attachments/files/113/510/253/309/575/753/original/993557ea4a718515.png",
"sig": "7a87a14ec71f8d4377477142fec2f6f108de1e8e9b1d2552f7eef3a6915380da2d81345c79daa6ed4b6d0efd5211bb889a4dba2aea4c24842ef18efebb1549b4"
}
