I'm doing some stuff on the server, so if it stops responding, or sending off the odd error don't be alarmed.. It's just me one handed server admining... Doing some testing on board software upgrades etc, but at times I will need to pull a snapshot from here which may bog things down.

Last edited by FishPants on Sun Jul 23, 2017 10:18 pm, edited 1 time in total.

Sounds about right.. Sorry for the server lag, was moving another DB around and figured it's getting too late.. just killed it. I need sleep, but I'm kinda stoked about the speed of recovery. That's good stuff.

Isgrimnur wrote:Joking aside, we appreciate the hard work to keep us together in our little backwater burgh.

Clearly what I was doing today caused it.. just not sure what.. I took a mysqldump of the site as a precaution (!!) before I did anything, then was poking around in other databases unrelated to this place. Not sure how that hosed the DB here, and logs weren't helpful.

Anyways a restore seemed to have chased the board goblins away. But come August, my wife and kids are away on a fabulous trip -- I'll be upgrading the board and sulking with my labradors (they sulk all the time).

Daehawk wrote:Really sorry FP. When I posted earlier about the failures I didn't mean for you to just jump in on Sunday. But after you started I couldn't post to say not to worry with it today.

Sorry mate. But thank you for that you did.

Nah I'm glad you did.. I turned off the admin block, board came up -- I saw topics and moved on. Never ran into that before when you click a topic title and it tells you it doesn't exist anymore (yet the database showed all the posts/data). Weird.

FishPants wrote:221 posts per second are being indexed.. I'm not doing the public math on what that means overall time wise, but I'd guess at least 6-8 hours.

3.11166415284062342885872297637 hours

We are about halfway now. I think it varies depending on how big the posts are and other load on the system. DB process is chewing up CPU which is good, means it's working -- and most of the DB is held in RAM so it can't get much faster than it is.

I require a reminder as to why raining arcane destruction is not an appropriate response to all of life's indignities. - VaarsuviusGlobal Steam Wishmaslist TrackingRunning 2014: 1300.55 milesRunning 2015: 2036.13 miles