[mkbhatia]

Around 5 pm PT, the main database for the forums crashed. It tooks us about about 2 hours to fix and while they were down, we also decided to repair seveal other tables to help solve the problems that we were experiencing on Thursday night and Friday afternoon. We are moving some stuff around this weekend to continue to improve performance. Sorry for the problems and hopefully, this bandaid fix will prove to work until next Monday or Tuesday.

best,
monish

[rickey939]

Thank you for your assistance! I assume next Monday or Tuesday is the forum design upgrade?

[Rolling Bones]

You should move the server out of the outhouse.

[tooki]

Whatever you guys did, M, it hasn't helped. The forums have been misbehaving as much today as they have earlier.

tooki

[rickey939]

Originally Posted by tooki

Whatever you guys did, M, it hasn't helped. The forums have been misbehaving as much today as they have earlier.

tooki

Hmm, I've seen a marked improvement actually.

[turtle777]

Originally Posted by Rolling Bones

You should move the server out of the outhouse.

-t

[turtle777]

Originally Posted by mkbhatia

Around 5 pm PT, the main database for the forums crashed. It tooks us about about 2 hours to fix and while they were down, we also decided to repair seveal other tables to help solve the problems that we were experiencing on Thursday night and Friday afternoon. We are moving some stuff around this weekend to continue to improve performance. Sorry for the problems and hopefully, this bandaid fix will prove to work until next Monday or Tuesday.

best,
monish

Short version:

They had to clean the hamster cage. It took 2 hrs.

-t

[mkbhatia]

So i optimized the databases again this morning and it seemed to help tremendously. The database seem to undergo quite a bit of corruption over time. I will have to look into automating the optimize function, which is far less resource-intensive than a repair, although it does back things up for 5-10 min.

Hope fully things are better. I know i see a lot less queries in the process list, which means they are being executed faster and there is no hold up for the delivery of pages! The improvement after optimization is remarkable.

m.

[rickey939]

Cool, thanks for your assistance!

[turtle777]

Originally Posted by mkbhatia

So i optimized the databases again this morning and it seemed to help tremendously. The database seem to undergo quite a bit of corruption over time. I will have to look into automating the optimize function, which is far less resource-intensive than a repair, although it does back things up for 5-10 min.

Hope fully things are better. I know i see a lot less queries in the process list, which means they are being executed faster and there is no hold up for the delivery of pages! The improvement after optimization is remarkable.

m.

Ok, so for the common folk:

The hamster's poop got stuck in the wheel and slowed down the hamster's roll.

-t

[tooki]

Originally Posted by mkbhatia

So i optimized the databases again this morning and it seemed to help tremendously. The database seem to undergo quite a bit of corruption over time. I will have to look into automating the optimize function, which is far less resource-intensive than a repair, although it does back things up for 5-10 min.

Hope fully things are better. I know i see a lot less queries in the process list, which means they are being executed faster and there is no hold up for the delivery of pages! The improvement after optimization is remarkable.

m.

How about finding the source of the corruption instead of applying a band-aid fix? Repairing/optimizing the DB is eventually going to fail when some specific constellation of corruption becomes irreparable.

tooki

[turtle777]

Originally Posted by tooki

How about finding the source of the corruption instead of applying a band-aid fix? Repairing/optimizing the DB is eventually going to fail when some specific constellation of corruption becomes irreparable.

What you mean is: get a new darn hamster !

-t

[tooki]

The hamster merely needs therapy so it'll stop crapping in its food dish is all.

tooki

[turtle777]

Originally Posted by tooki

The hamster merely needs therapy so it'll stop crapping in its food dish is all.

NOW I get it.

-t