Scheduled database maintenance: 2012-04-26

Questions about the forums? Got a suggestion on how things can be improved? Post here!
Post Reply
User avatar
Ron2K
Forum Technical Administrator
Posts: 9050
Joined: 04 Jul 2006, 16:45
Location: Upper Hutt, New Zealand
Contact:

Scheduled database maintenance: 2012-04-26

Post by Ron2K »

Hello

I will be performing some minor database maintenance (mainly some optimisations) on Thursday, April 26 2012 at 2100Z (please add or subtract your region's UTC offset to obtain your local time). This should take less than an hour to complete.

Please note that the forum will be unavailable while the maintenance is being performed.
Kia kaha, Kia māia, Kia manawanui.
User avatar
hamin_aus
Forum Moderator
Posts: 18358
Joined: 28 Aug 2003, 02:00
Processor: Intel i7 3770K
Motherboard: GA-Z77X-UP4 TH
Graphics card: EVGA GTX680 SC
Memory: 32GB G.Skill Ripjaws
Location: Where beer does flow and men chunder
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by hamin_aus »

What kind of optimizations :?:
Image
User avatar
Ron2K
Forum Technical Administrator
Posts: 9050
Joined: 04 Jul 2006, 16:45
Location: Upper Hutt, New Zealand
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Ron2K »

^^ Index reorganisation, defragmentation -- in other words, your standard DBA kind of tasks. I'll also be adding some indexes to tables that I've identified the need for.

Like I said, it won't take long to do. It's just rather overdue, that's all.
Kia kaha, Kia māia, Kia manawanui.
User avatar
hamin_aus
Forum Moderator
Posts: 18358
Joined: 28 Aug 2003, 02:00
Processor: Intel i7 3770K
Motherboard: GA-Z77X-UP4 TH
Graphics card: EVGA GTX680 SC
Memory: 32GB G.Skill Ripjaws
Location: Where beer does flow and men chunder
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by hamin_aus »

Ah, Indexing in MySQL :lol:

Best of luck, brosef!
Image
User avatar
Tribble
Registered User
Posts: 88457
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Tribble »

YAY! My post count is going to drop again :D
Image
User avatar
Prime
Registered User
Posts: 27723
Joined: 01 Mar 2004, 02:00
Location: Getting into trouble
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Prime »

Drop Database
User avatar
Tribble
Registered User
Posts: 88457
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Tribble »

Don't push him - if he does that we would have no where to go :shock:
Image
User avatar
Ron2K
Forum Technical Administrator
Posts: 9050
Joined: 04 Jul 2006, 16:45
Location: Upper Hutt, New Zealand
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Ron2K »

Prime wrote:Drop Database
Standard procedure is to perform a full backup of the database before commencing maintenance operations; the chance of this happening is negligible.
Kia kaha, Kia māia, Kia manawanui.
Sojourn
Registered User
Posts: 5649
Joined: 02 Sep 2004, 02:00
Location: Still looking...

Re: Scheduled database maintenance: 2012-04-26

Post by Sojourn »

add null statements
User avatar
Tribble
Registered User
Posts: 88457
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Tribble »

Yes - add a null statement to my post count.
Image
User avatar
Prime
Registered User
Posts: 27723
Joined: 01 Mar 2004, 02:00
Location: Getting into trouble
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Prime »

Ron2K wrote:
Prime wrote:Drop Database
Standard procedure is to perform a full backup of the database before commencing maintenance operations; the chance of this happening is negligible.
Sense of humour fail :facepalm:

I hope you repair it with the database maintenance! :P
User avatar
Ron2K
Forum Technical Administrator
Posts: 9050
Joined: 04 Jul 2006, 16:45
Location: Upper Hutt, New Zealand
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Ron2K »

Database maintenance has been completed.
Kia kaha, Kia māia, Kia manawanui.
Monty
Forum Moderator
Posts: 10000
Joined: 05 Feb 2004, 02:00
Processor: Intel i5-4690K @ 4.5GHZ
Motherboard: ASUS Maximus VII Formula
Graphics card: ASUS GTX970 Strix
Memory: 4 x 4GB Corsair Dominators
Location: Messing with your Mind
Contact:

Scheduled database maintenance: 2012-04-26

Post by Monty »

Thanks Ron!
Art Williams wrote:I'm not telling you it is going to be easy, I'm telling you it's going to be worth it.
ADT
Registered User
Posts: 19503
Joined: 07 Oct 2009, 08:34
Location: West of the desert

Re: Scheduled database maintenance: 2012-04-26

Post by ADT »

ya thanks ron you killed it :P
Image
Kanete naki mi koso yasukere yuki no michi
Spoiler (show)
AMD Phenom II 3.47ghz ~ Gigabyte GA-890GPA-UD3H ~ XFX Radeon HD 5770 ~ CM eXtreme Power Plus 600W PSU ~ Samsung P2370H ~ Corsair 4GB DDR3 2000 Mhz ~ Win 7 64 Bit Ultimate ~
User avatar
Tribble
Registered User
Posts: 88457
Joined: 08 Feb 2007, 02:00
Processor: Intel Core i7-4770K CPU@3.50GHz
Motherboard: ACPI x64-based PC
Graphics card: GeForce GTX 780 Ti
Memory: 16GB
Location: Not here
Contact:

Re: Scheduled database maintenance: 2012-04-26

Post by Tribble »

I didn't lose a post count :(
Image
User avatar
THE_STIG
Spoiled Brat
Posts: 11762
Joined: 26 Aug 2010, 20:33
Processor: Core i7 6800k
Motherboard: Asrock x99 taichi
Graphics card: Zotac 1080ti amp extreme
Memory: 16gb(4x4gb) corsair vengeance
Location: Some say.......

Re: Scheduled database maintenance: 2012-04-26

Post by THE_STIG »

ADT wrote:ya thanks ron you killed it :P
At first I thought your let vista burn comment killed it :lol: :lol: then I remembered about the maintenance
Post Reply