Sean, can you go up to our BugTracker and enter that--and don't forget to include browser and OS type and version information.
Yeah, I could do that, but I'm paralyzed with not caring very much.
Spike ,'Showtime'
Buffistas Building a Better Board ++
Do you have problems, concerns, or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
§ ita § - Jul 30, 2008 10:43:46 am PDT #2432 of 4673
Well not canonically, no, but this is transformative fiction.
omnis_audis - Jul 30, 2008 10:17:10 pm PDT #2433 of 4673
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir
I would love to be part of a new LAista list, fwiw. I don't expect us all to be best friends, but it would be nice to get together now and then.Sure, now that I'm not there... :: weeps ::
t /annoying cry baby
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.