PDA

View Full Version : DB maintenance tonight.



BraindG
22-05-2006, 11:51 AM
Tonight I am going to run some maintenance on our Database, giving it a bit of a spring clean to to speak. I don't foresee any issues, and I won't be running it while everyone is on the site. However you may notice some slow down later on in the evening.

The maintenance involves the following.

Checking for errors.
Reclaim unused Space.
Fix Broken profiles
Update post Count.
Rebuilding Forum/thread information
Rebuild attachments.
Rebuild Search Index.

I have not performed this updates since the site was upgraded, so Its about time I done so :)

You See
22-05-2006, 12:09 PM
Sounds like a good idea Barry....as I'll be at work it won't effect me watsoever! ...and unlike most of you, I'm too busy at work doing work, rather than surfing sites! :P

BraindG
22-05-2006, 12:12 PM
...and unlike most of you, I'm too busy at work doing work, rather than surfing sites! :P

Im multitasking at work :) - on the phone, and posting :inquisiti (although, i may not be making sense to the person on the phone.)

Spirit
22-05-2006, 01:03 PM
Thanks for the heads-up Barry :2thumbsup

BraindG
22-05-2006, 11:49 PM
I didn't get much completed, the Search Index seems to be taking a long time, and im wanting to go to bed now - its only a 50k out of 150k :(

So far I have.
Checking for errors..
Rebuilding Forum/thread information.
Rebuild reputation points.

Ill continue in morning.

Spirit
23-05-2006, 12:27 AM
Rebuild reputation points.


Just looked at my CP and my points have gone down and I have lost a green box - will it come back ?

BraindG
23-05-2006, 06:41 AM
Just looked at my CP and my points have gone down and I have lost a green box - will it come back ?
hmm, it recounts all the repoints received, it should also remove the 0 rep points aswell, you know the white dots? but no, it won't come back now, as its recalculated from current rep points.

Physician
23-05-2006, 06:44 AM
Just looked at my CP and my points have gone down and I have lost a green box - will it come back ?

Bahahahaha! What do the kids say today? .......... Owned! Ha! :evilgrin:

Spirit
23-05-2006, 08:54 AM
Bahahahaha! What do the kids say today? .......... Owned! Ha! :evilgrin:

It's no issue - I knew them exactly so I have changed it back :2thumbsup Barry/Kieran, looks like both of yours have dropped too ?

Thanks for being so sensitive Rich.........you b****ard ! /haz

BraindG
23-05-2006, 09:01 AM
Im not bothered really.

tig202
23-05-2006, 10:38 PM
I only had the one green box and miss it now/help and still cannot find who gave it to me as there is no option to do so in user cp:book: :speechles

HJM
23-05-2006, 10:43 PM
I only had the one green box and miss it now/help and still cannot find who gave it to me as there is no option to do so in user cp:book: :speechles

What are you on about - you still have one :inquisiti


J :happy:

tig202
23-05-2006, 10:48 PM
Honest J, it was not there b4!!!!
Either that or I was still a lil hungover from the weekend:5shots:

HJM
23-05-2006, 10:58 PM
Honest J, it was not there b4!!!!
Either that or I was still a lil hungover from the weekend:5shots:

Are you sure :inquisiti


:happy:

SGHOM
23-05-2006, 11:00 PM
Are you sure :inquisiti


:happy:
I'm sure ?? I was just about to turn Steve green...... when it suddenly appeared ??
:thinking: :inquisiti :inquisiti

HJM
23-05-2006, 11:02 PM
I'm sure ?? I was just about to turn Steve green...... when it suddenly appeared ??
:thinking: :inquisiti :inquisiti

Nah, you imagined it as well - it was always green - men /pan



J :evilgrin:

tig202
23-05-2006, 11:05 PM
I was pretty green on sunday morning:thinking:

HJM
23-05-2006, 11:06 PM
I was pretty green on sunday morning:thinking:


Ha, lightweight :5shots:

SGHOM
23-05-2006, 11:07 PM
Ha, lightweight :5shots:

I was up at the crack of dawn for work ! :scholar: :scholar:




Tuesday !! :5shots: :5shots: /help

BraindG
23-05-2006, 11:08 PM
Ha, lightweight :5shots:
at 4.75 im sure you were a lightwieght aswell! :D

Wodjno
24-05-2006, 09:17 AM
I was pretty green on sunday morning:thinking:

Did you have a couple of Shandy's then ?? :5shots: :sick2:

tig202
24-05-2006, 06:48 PM
Well we did drink the Ibis dry of Carling:5shots: :5shots: /pan :5shots: :5shots:

BraindG
24-05-2006, 06:58 PM
Well we did drink the Ibis dry of Carling:5shots: :5shots: /pan :5shots: :5shots:
hehe, and then onto the rash inducing Grolsch /Grrr