Scheduled database maintenance: 2012-04-26
- Ron2K
- Forum Technical Administrator
- Posts: 9050
- Joined: 04 Jul 2006, 16:45
- Location: Upper Hutt, New Zealand
- Contact:
Scheduled database maintenance: 2012-04-26
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.
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.
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: Scheduled database maintenance: 2012-04-26
What kind of optimizations
- 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
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.
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.
- hamin_aus
- Forum Moderator
- Posts: 18363
- Joined: 28 Aug 2003, 02:00
- Processor: Intel i7 3770K
- Motherboard: GA-Z77X-UP4 TH
- Graphics card: Galax GTX1080
- Memory: 32GB G.Skill Ripjaws
- Location: Where beer does flow and men chunder
- Contact:
Re: Scheduled database maintenance: 2012-04-26
Ah, Indexing in MySQL
Best of luck, brosef!
Best of luck, brosef!
- Tribble
- Registered User
- Posts: 88465
- 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
YAY! My post count is going to drop again
- Prime
- Registered User
- Posts: 27729
- Joined: 01 Mar 2004, 02:00
- Location: Getting into trouble
- Contact:
Re: Scheduled database maintenance: 2012-04-26
Drop Database
- Tribble
- Registered User
- Posts: 88465
- 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
Don't push him - if he does that we would have no where to go
- 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
Standard procedure is to perform a full backup of the database before commencing maintenance operations; the chance of this happening is negligible.Prime wrote:Drop Database
Kia kaha, Kia māia, Kia manawanui.
Re: Scheduled database maintenance: 2012-04-26
add null statements
- Tribble
- Registered User
- Posts: 88465
- 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
Yes - add a null statement to my post count.
- Prime
- Registered User
- Posts: 27729
- Joined: 01 Mar 2004, 02:00
- Location: Getting into trouble
- Contact:
Re: Scheduled database maintenance: 2012-04-26
Sense of humour failRon2K wrote:Standard procedure is to perform a full backup of the database before commencing maintenance operations; the chance of this happening is negligible.Prime wrote:Drop Database
I hope you repair it with the database maintenance!
- 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
Database maintenance has been completed.
Kia kaha, Kia māia, Kia manawanui.
-
- 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
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.
Re: Scheduled database maintenance: 2012-04-26
ya thanks ron you killed it
Kanete naki mi koso yasukere yuki no michi
- Spoiler (show)
- Tribble
- Registered User
- Posts: 88465
- 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
I didn't lose a post count
- 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
At first I thought your let vista burn comment killed it then I remembered about the maintenanceADT wrote:ya thanks ron you killed it