npub1slyc6w2fy6t7sk7e5caxclu2dn629l35n4tkjyxzrqndkpq86x2sfut8j7 (npub1sly…t8j7) Thanks for reaching out! It's MySQL 5.7, running as a service so getting access to the box is a little more difficult.
Slow queries are on now, but logging to a file I can't figure out how to get access to unfortunately.
I made a little progress and discussed the issue a little more here -- would be curious if you have any other input, or if you think partitioning the table might be worth it: https://github.com/writefreely/writefreely/issues/741
Matt Baer /
npub1eh…6ysfx
2023-08-11 21:54:17
in reply to nevent1q…jdyy
Author Public Key
npub1eh33dlkkp8kgj6w8jffsn5wqpte8wwfavxl90xq0huu8h7qvdh5sk6ysfxPublished at
2023-08-11 21:54:17Event JSON
{
"id": "43e898df2a08bcbe3e976e2f20c77f9248728ca5088691afea48310c6d8a82a6",
"pubkey": "cde316fed609ec8969c7925309d1c00af277393d61be57980fbf387bf80c6de9",
"created_at": 1691790857,
"kind": 1,
"tags": [
[
"p",
"87c98d39492697e85bd9a63a6c7f8a6cf4a2fe349d576910c21826db0407d195",
"wss://relay.mostr.pub"
],
[
"p",
"6527ed4b3886f3e9a14483f38015e966febecb851259510ff54cb2cebfc4e6fa",
"wss://relay.mostr.pub"
],
[
"e",
"7c642a5ec81890ef46a7efcf901f3656d1f286e979616ba5d1e45cb59c645d1e",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://writing.exchange/users/matt/statuses/110873205622871693",
"activitypub"
]
],
"content": "nostr:npub1slyc6w2fy6t7sk7e5caxclu2dn629l35n4tkjyxzrqndkpq86x2sfut8j7 Thanks for reaching out! It's MySQL 5.7, running as a service so getting access to the box is a little more difficult.\n\nSlow queries are on now, but logging to a file I can't figure out how to get access to unfortunately.\n\nI made a little progress and discussed the issue a little more here -- would be curious if you have any other input, or if you think partitioning the table might be worth it: https://github.com/writefreely/writefreely/issues/741",
"sig": "e7c35a3fca10a954de5c5ab6ed3531d6c48c0679644dcf1e8a5e8ca87de68c0a1a090d6a62d7a4d68a2d8e7bed283f1c537fc12caa090fa4ef370c68bfa41f8f"
}