APUG--brought down by the "deleted" and joke threads. Well, those would be no great loss.
Things seem improved after moving a few mega-threads from view. What I noticed was the site running fine, then a big slow down. After gaining access to the mysql database process log, every time the site went slow there would be a thread id in the queued processes. Each id corresponded to an extremely large thread. Threads like "your latest 35mm camera purchase" or the "deleted" thread. There were several Kodak ones as well. I'll get these threads back into view soon but locked down and we can create a "part2" for them. For now seems safest to stash them away. It's still hard to tell 100% if that was the issue.
Copying to tmp table | SELECT DISTINCT t.threadid,t.title
FROM post AS p
LEFT JOIN thread AS t ON (p.threadid=t.threa |{/quote]
Trying to find out what component in our software is generating this. I think once we can get rid of that things will be a lot better.
Site performance seems spotty this morning, sometimes taking a minute or so to load a page.
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?