or Connect
Styleforum › Forums › General › General Chat › Transparent Moderation Log & Site Topics - Part I
New Posts  All Forums:Forum Nav:

Transparent Moderation Log & Site Topics - Part I - Page 540  

post #8086 of 9842
three cheers!
post #8087 of 9842
Christ that was way more difficult than it should have been. <- might need to get a life.
post #8088 of 9842
Thread Starter 
Pasting what I posted last night while it was up for a while and before it started acting sketchy again:
Quote:
Sorry, and don't blame Huntsman, but I (along with about 6 various people at the server) did unwillingly spend the whole day (starting at 2 AM PST) fighting with the forum database. Some was accomplished but not much of what I wanted to get done at all. I expected to have the site down a couple hours in the middle of the night and repair the main 'post' table since I suspect it is part of the source of the slow queries lagging down the site. Unfortunately, neither I nor anyone available at the time knew that if you try a repair on a table bigger than your /tmp directory (2GB in our case) the repair will hang, forcing a restart of mySQL, and marking the table as 'crashed'. The temp files it creates are deleted upon doing this, so you won't find them there afterwards. Which means unless you know about this (it's buried in a sub-appendix of the mySQL docs ) mySQL will just sit there and spin looking like it's maybe kinda repairing something that should take quite a while to repair, while really it's doing nothing. And of course it doesn't tell you anything to the effect of 'temp space full, repair cannot proceed'. So at least, while waiting for this to happen (nothing was happening) I got a couple hours of sleep. Meanwhile I had them restore a backup snapshot from right before I started the repair. Yada yada, both ended up working but this copy is the original (more complete, shouldn't be missing any posts from last night) and we did finally get the repair to go through, so whatever was wonky before is hopefully fixed. I will still need to take it down again sometime to re-optimize the table but I am going to prune off as much data as I can get away with first to try to get it down to a more reasonable size. If anything seems missing, let me know, we can merge stuff in from the snapshot from before everything went crazy last night. Again, sorry for the withdrawals, hopefully everyone is fine and didn't accomplish too much today. If everything looks okay, it is now time for me to go drink.
We ended up restoring another copy of the backup from before all the mess started and that's what we're running now. Now as soon as everything looks okay, it will be time for me to go sleep for 16 hours or so.
post #8089 of 9842
Quote:
Originally Posted by Manton View Post
Laaaaaaaaaaaaaaaaagggggggggggggg1111111111111111!!!!!!!!!!

Just wanted to let the mods know: I noticed some really bad lag yesterday and today. Pages were taking like 30 hours to load.
post #8090 of 9842
Thread Starter 
Quote:
Originally Posted by MrG View Post
Just wanted to let the mods know: I noticed some really bad lag yesterday and today. Pages were taking like 30 hours to load.
post #8091 of 9842
^
post #8092 of 9842
Thanks, j!!
post #8093 of 9842
why don't we redesign/architect this site? thoughts?

Quote:
Originally Posted by j View Post
post #8094 of 9842
Thread Starter 
Quote:
Originally Posted by thekunk07 View Post
why don't we redesign/architect this site? thoughts?
Well first I want to get the database running as well as possible and upgrade to the latest version of the forum software. Generally it's quite good at what it does and I don't want to go to a proprietary system that I will understand even less well than this. But some redesign will definitely be necessary for some of the stuff we want to do.
post #8095 of 9842
Man, you guys are dedicated.

post #8096 of 9842
<waiting for Manton's post>
post #8097 of 9842
Quote:
Originally Posted by MrG View Post
Just wanted to let the mods know: I noticed some really bad lag yesterday and today. Pages were taking like 30 hours to load.



to J
post #8098 of 9842
just pm me your im and email at some point. we have tackled more tempestuous sites and there is some good shit we could be doing together.

Quote:
Originally Posted by j View Post
Well first I want to get the database running as well as possible and upgrade to the latest version of the forum software. Generally it's quite good at what it does and I don't want to go to a proprietary system that I will understand even less well than this. But some redesign will definitely be necessary for some of the stuff we want to do.
post #8099 of 9842
So, to be clear, this mini crash we had to go through - that was because of Manton's complaints about lags, right?
post #8100 of 9842
Quote:
Originally Posted by gdl203 View Post
So, to be clear, this mini crash we had to go through - that was because of Manton's complaints about lags, right?
Yes, it was his fault.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: General Chat
This thread is locked  
Styleforum › Forums › General › General Chat › Transparent Moderation Log & Site Topics - Part I