I couldn't tell a damned thing. The whole internet is thrashing for me today.
Last time were were severely slow I went through the queries and checked the indices and MySQL wasn't complaining, so I ruled that out as a major contributor.
We've had a lovely luxury of not archiving in the longest time--so you have a sense of the size of this database compared to other MySQL databases? Are we that big?
I can check table later tonight unless you think it's very urgent.
I don't have enough experience with MySQL to know how big is too big, but we're closing in on a million rows in the posts table.
[edit: and it took me 15 seconds to run a "select count(*) from posts" query]
This feels sudden and I don't like that one bit. But archiving can't hurt.
DX? You around?
Okay, yeah, it's taking me a long time to post.
What do you mean it feels sudden? The board has had these fits of slowness for a long time now.
The board is super-slow today.
It's even slower than usual today (usual slowness is due to crappy internet)
Insanely slow. Dropped into this thread to see if I was the only one.
Will time post wait.... 1:43 from when I hit post the first time.
Was it very slow for you yesterday? It wasn't for me. But, as noted, my entire connection is slow today, so I can't make a comparison. Your query duration looked very long, though.
Board is noticeably slower today for me than it was yesterday.
I haven't posted in a few days so I didn't notice until today.