Have you enabled and looked at the slow query log?
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
Here's a broad approach: https://coderpad.io/blog/development/optimize-query-performance-mysql/
npub15wawnk00h6gfnwpkvx7p74cel8uy99tl9z6mdyhtt7lk2tcvptxq2rezxc (npub15wa…ezxc)
Brad Rubenstein “:verified:” /
npub10a…arf48
2023-08-11 14:35:38
in reply to nevent1q…x24s
Author Public Key
npub10atl5ncccgzjpaym0599cxuu4pfjhtvxdseg6mnn6l0yx92tjlcs3arf48Published at
2023-08-11 14:35:38Event JSON
{
"id": "b8350d488ec819e9776799a07c53c26ceb4f48ffeb5ed31452fd3b77b4c21882",
"pubkey": "7f57fa4f18c20520f49b7d0a5c1b9ca8532bad866c328d6e73d7de43154b97f1",
"created_at": 1691764538,
"kind": 1,
"tags": [
[
"p",
"a3bae9d9efbe9099b83661bc1f5719f9f842957f28b5b692eb5fbf652f0c0acc",
"wss://relay.mostr.pub"
],
[
"p",
"cde316fed609ec8969c7925309d1c00af277393d61be57980fbf387bf80c6de9",
"wss://relay.mostr.pub"
],
[
"e",
"d012b466733644d7521bd402f0c96b3874450a449d51ef25cc61f029b305daf0",
"wss://relay.mostr.pub",
"reply"
],
[
"content-warning",
"re: WriteFreely scaling help"
],
[
"proxy",
"https://infosec.exchange/users/BradRubenstein/statuses/110871480786329893",
"activitypub"
]
],
"content": "Have you enabled and looked at the slow query log?\n\nhttps://dev.mysql.com/doc/refman/5.7/en/log-destinations.html\n\nHere's a broad approach: https://coderpad.io/blog/development/optimize-query-performance-mysql/\n\nnostr:npub15wawnk00h6gfnwpkvx7p74cel8uy99tl9z6mdyhtt7lk2tcvptxq2rezxc",
"sig": "c223fca1b6a4c590c831c4395854392224195ad71fc51f29ac63c3b51a7748ccc6114d26eb9c1cae6b8161549df415cc6f8fa171b8a1b60433e5d674e60db6d4"
}