Danke Michael Vogel (nprofile…rgpg), aber das habe ich schon versucht. Leider ohne erfolg:
MariaDB [friendica]> OPTIMIZE TABLE `post-user`;
+---------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+----------+----------+-------------------------------------------------------------------+
| friendica.post-user | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| friendica.post-user | optimize | error | Can't open table |
| friendica.post-user | optimize | status | Operation failed |
+---------------------+----------+----------+-------------------------------------------------------------------+
3 rows in set, 1 warning (0,016 sec)
Tuxi (Backup) /
npub1m8…v8gv5
2025-03-14 17:28:19
in reply to nevent1q…ayyq
Author Public Key
npub1m8vp0dqs8f9t2d7chs6mgze0rxy9wpxqj2thpyufey8vkv64dq6qfv8gv5Published at
2025-03-14 17:28:19Event JSON
{
"id": "5b31cba4833292bca0f4e2af062b4f291a981bc7729d2e079b1ed5ee88a0608c",
"pubkey": "d9d817b4103a4ab537d8bc35b40b2f19885704c09297709389c90ecb33556834",
"created_at": 1741973299,
"kind": 1,
"tags": [
[
"p",
"9d890fa7852c95a6cfdac237f1267882e5d8779fef504115edea5e32bc7369d1",
"wss://relay.mostr.pub"
],
[
"e",
"027577c58529d88a1decae037ca813bd41bc8fc242ab3d0c3f9c97495b2d7afb",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://friendica.opensocial.space/objects/8ffdf77c-5367-d467-3351-b40738051153",
"activitypub"
]
],
"content": "Danke nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqnkyslfu99j26dn76cgmlzfncstjasaulaagyz90daf0r90rnd8gsgtrgpg, aber das habe ich schon versucht. Leider ohne erfolg:\nMariaDB [friendica]\u003e OPTIMIZE TABLE `post-user`;\n+---------------------+----------+----------+-------------------------------------------------------------------+\n| Table | Op | Msg_type | Msg_text |\n+---------------------+----------+----------+-------------------------------------------------------------------+\n| friendica.post-user | optimize | note | Table does not support optimize, doing recreate + analyze instead |\n| friendica.post-user | optimize | error | Can't open table |\n| friendica.post-user | optimize | status | Operation failed |\n+---------------------+----------+----------+-------------------------------------------------------------------+\n3 rows in set, 1 warning (0,016 sec)",
"sig": "bb393ae323f63309ca7f5ec8cc4578fe1611e53f96e92162e41d70a8e7e1abedc18d4d684adcc387d4034f423a279454c15db28657544bac20d7407274598de8"
}