Buffistas.org
River: They weren't cows inside. They were waiting to be, but they forgot. Now they see the sky and they remember what they are. Mal: Is it bad that what she said made perfect sense to me?

'Safe'

Buffistas Building a Better Board ++

Site Administration

Do you have problems, concerns, or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.

First Previous Next Last Recent
Tom Scola - Aug 05, 2008 8:19:20 am PDT #2434 of 4673
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.

The board is super-slow today. Here's a snapshot of what's going on on the system:

Cpu(s): 4.7% us, 2.0% sy, 0.0% ni, 0.0% id, 93.3% wa, 0.0% hi, 0.0% si

That "93.3% wa" is I/O wait, which means that the system is spending 93% of its time reading and writing to the disk. Basically, the CPUs are sitting mostly idle while they wait for disk reads to complete. Basically, MySQL is thrashing the system.

Things we could try that could fix things in the short term are:

    • Running any of CHECK TABLE/REPAIR TABLE/OPTIMIZE TABLE on the posts table.
    • Archiving and deleting a bunch of stuff from the posts table.
    • Making extra sure that everything is indexed like it's supposed to be.

§ ita § - Aug 05, 2008 8:26:23 am PDT #2435 of 4673
Well not canonically, no, but this is transformative fiction.

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.

Tom Scola - Aug 05, 2008 8:30:38 am PDT #2436 of 4673
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.

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]

§ ita § - Aug 05, 2008 8:51:03 am PDT #2437 of 4673
Well not canonically, no, but this is transformative fiction.

This feels sudden and I don't like that one bit. But archiving can't hurt.

DX? You around?

Polter-Cow - Aug 05, 2008 8:56:18 am PDT #2438 of 4673
What else besides ramen can you scoop? YOU CAN SCOOP THIS WORLD FROM DARKNESS!

Okay, yeah, it's taking me a long time to post.

Tom Scola - Aug 05, 2008 8:57:20 am PDT #2439 of 4673
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.

What do you mean it feels sudden? The board has had these fits of slowness for a long time now.

Vortex - Aug 05, 2008 9:01:16 am PDT #2440 of 4673
"Cry havoc and let slip the boobs of war!" -- Miracleman

The board is super-slow today.

It's even slower than usual today (usual slowness is due to crappy internet)

Laura - Aug 05, 2008 9:17:05 am PDT #2441 of 4673
Our wings are not tired.

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.

§ ita § - Aug 05, 2008 9:20:04 am PDT #2442 of 4673
Well not canonically, no, but this is transformative fiction.

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.

Laga - Aug 05, 2008 9:25:15 am PDT #2443 of 4673
You should know I'm a big deal in the Resistance.

Board is noticeably slower today for me than it was yesterday.

First Previous Next Last Recent