Getting worse | Page 3 | Fab Forum

Introducing the inaugural Fab Forum February Fundraiser! Click here for more details.

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 4 characters - maximum search word length is 84 characters

sp_Feed sp_TopicIcon
Getting worse
No permission to create posts
27 April 2012
7.14pm
Avatar
Joe
Pepperland
Admin
Forum Posts: 4390
Member Since:
31 March 2008
sp_UserOfflineSmall Offline

Hi. I know. Sorry, really sorry. I'm fed up with this flaky host - I think I'll have to find a new company. My sysadmin can't get to the bottom of it and I've lost patience.

Delay in mentioning it was because Ted was rushed to hospital on Weds. Thankfully ok, just precautionary, but he stayed the night there. So site downtime wasn't at the top of my list. Birthday was lovely, apart from the hospital thing in the morning. Got a new iPad! Typing this on it now.

Anyway, bear with me. I'll look for a new host and will migrate the site as soon as I can.

Please don't spoil my day; I'm miles away

Can buy me love! Please consider using these links to support the Beatles Bible: Amazon | iTunes

28 April 2012
12.29am
Avatar
Into the Sky with Diamonds
New York
Apple rooftop
Forum Posts: 1535
Member Since:
9 August 2011
sp_UserOfflineSmall Offline
3 May 2012
3.07pm
Avatar
Joe
Pepperland
Admin
Forum Posts: 4390
Member Since:
31 March 2008
sp_UserOfflineSmall Offline

Hi all. I have a new server, which I've been busy preparing (with some great assistance from the hosting company, servint.net, which have been very patiently talking me through the process).

The site hasn't been migrated yet; I've been busy backing up files and getting everything ready. I've got a couple of much smaller sites I want to move over first, just to make sure I know what I'm doing (The Beatles Bible is a mammoth site in comparison, and there's much more that could go wrong - the database is enormous, and there are thousands of image files of various sizes).

I wanted to post this just so you know what's going on. Also, at some point I'll have to make a backup of the database and upload it to the new server, then point the domain name (beatlesbible.com) to the new place. During that crossover time there's a chance that some comments and forum posts will get lost - this is unfortunate but unavoidable. I'll do it earlyish in the morning, UK time, so most of the American users (the bulk of my visitors) are likely to be asleep, which will minimise the losses.

I've got a bit of time Saturday/Sunday/Monday, so I'll hopefully get it all done by then. It's worth taking care with, I hope you'll agree. That doesn't mean I won't get something wrong though paul-mccartney

The new server is fully managed, which means if something's not set up correctly I can get professional people to look into and fix it. ServInt came highly recommended on webhostingtalk.com, where these things are debated and discussed (and many companies don't come off well). I can't promise there'll never be any more downtime, but things should be more stable than they have been.

7 May 2012
12.42pm
Avatar
Joe
Pepperland
Admin
Forum Posts: 4390
Member Since:
31 March 2008
sp_UserOfflineSmall Offline

Hi. I don't know if anyone else can read this at the moment - I hope so.

It's been an interesting couple of days. I moved the site to a new server. All went OK, but the pages were loading quite slowly. The new hosts pointed out that the database was over 5 gigabytes - pretty massive. I noticed that one of the database tables was caching absolutely tons of data which it shouldn't have been, and was probably the cause of all the downtime over the last few months. This one table entry was 5.1 GB (and should have been about 100 KB), and when I tried to run scripts to reduce its size the server would run out of memory because it was so massive.

I asked the host to temporarily move me to a server with more memory. This they did, though the rogue database table was still threatening to overload the server. So they made the site accessible only to my IP address while I carried out the housekeeping. Hopefully it's now open to all again. The database table which was 5.1 GB is now 188 KB - hurrah.

Then a few other things typically went wrong, bits and pieces of code that were awry, but hopefully it's largely running OK now. I'll keep an eye on things, and I'm still looking at ways to get things running as efficiently/quickly as possible. However, the bottom line is that the site is back, should (fingers crossed) remain up. Please let me know if you spot anything that looks broken (here is best - I'm not sure the email is working properly at the moment).

Sorry for the downtime. Your loyalty and patience is always appreciated.heart

No permission to create posts
Forum Timezone: America/Chicago

Most Users Ever Online: 597

Currently Online: Ahhh Girl, Annadog40, Merch, Silly Girl, Beatles007
53 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

meanmistermustard: 17131

Ahhh Girl: 10745

Annadog40: 9719

Zig: 7548

parlance: 7092

mr. Sun king coming together: 6980

Mr. Kite: 6092

Silly Girl: 5792

trcanberra: 5541

Ron Nasty: 4940

Member Stats:

Guest Posters: 87

Members: 3331

Moderators: 4

Admins: 2

Forum Stats:

Groups: 3

Forums: 42

Topics: 3815

Posts: 202114

Newest Members:

pbwriter, leenawilliams, ravenswolf, Gamer1234, Stockholm1955

Moderators: Ahhh Girl: 10745, meanmistermustard: 17131, Zig: 7548, Joe: 4390

Administrators: Joe: 4390, Ellie: 3

Members Birthdays
sp_BirthdayIcon
Today: None
Upcoming: DrBeatle