Forums
First  << 1  2  3 >>  Last
Forum Main>>Announcements>> Delete Script
Chedburn

ID: 1
Level: 35
Posts: 7240
Score: 12650
Chedburn [1]Reply | Quote | Report

Last replied to on Sat Dec 15, 2007 17:59:42
An old data delete script was what caused the short 15 minute downtime period just then.

We have 30GB of unused logs and other data which needs to be removed in order for our backup time to be reduced. Running one of the scripts (deleting 4GB of the 30GB) managed to bring the whole site to a crawl and prevent logging in.

Once the 30GB is deleted, we can keep up with the data by deleting old stuff every day, the mistake we made was leaving it a year - 40,000,000 rows of data can't be deleted within a few seconds.

So... I imagine the only way forward is to bring the site down for a few hours for a nice clean up. I think we can do this tomorrow or the day after. I will post up an announcement 24 hours in advance.

Thanks!

Ched.jpg
Super secret reinforced spam barrier 2.0
Toa
ID: 264829
Level: 24
Posts: 103
Score: 0
Toa [264829]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:04:59
ok

"I may not always not always be right, but I am never wrong"
Super secret reinforced spam barrier 2.0
6268
ID: 6268
Level: 55
Posts: 2367
Score: 14
6268 [6268]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:05:23
Thanks for the heads up Ched!

Cloud-2-1.gif
Super secret reinforced spam barrier 2.0
GayBadBoy

ID: 158696
Level: 58
Posts: 2147
Score: 618
CgDhGayBadBoy [158696]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:05:34
Thanks Ched!


Edited by: GayBadBoy on 06/12/07 at 8:06:19 AM

gbb.gif
697431627948742xe3.gif
Super secret reinforced spam barrier 2.0

ID:
Level:
Posts:
Score:
 []Edit | Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:05:38
Lol, thats alot of data

Super secret reinforced spam barrier 2.0
Grindina

ID: 276310
Level: 25
Posts: 284
Score: 4
Grindina [276310]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:05:39
gg

banner12nf0.jpg
Super secret reinforced spam barrier 2.0
Razed

ID: 258049
Level: 50
Posts: 431
Score: 0
Razed [258049]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:06:00
you show that data whos the boss and delete its ass

razed.jpg
Super secret reinforced spam barrier 2.0
Zer0CooL

ID: 298394
Level: 71
Posts: 625
Score: 169
Zer0CooL [298394]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:06:43
thx for the explanation -
you're still doing great work mate :-)

Super secret reinforced spam barrier 2.0

ID:
Level:
Posts:
Score:
 []Edit | Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:06:43
ok...

Super secret reinforced spam barrier 2.0
Nice-Guy-Eddie
ID: 535562
Level: 19
Posts: 9
Score: 0
Nice-Guy-Eddie [535562]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:06:48

ok
Signature:



Super secret reinforced spam barrier 2.0
RumbLE

ID: 227744
Level: 37
Posts: 142
Score: 1
RumbLE [227744]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:08:59
Thank you

Super secret reinforced spam barrier 2.0
Ohadik

ID: 424017
Level: 78
Posts: 4493
Score: 3782
lfcpOhadik [424017]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:09:21
nice, do it at like 6:00-8:00 servertime because I am usually asleep then

kidahosig0010.jpg
Super secret reinforced spam barrier 2.0
_Psychosocial_

ID: 309085
Level: 59
Posts: 1831
Score: 50
DV_Psychosocial_ [309085]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:10:04
thanks for letting us know dude

Psychosocialcopy.png
SMAllNEWzeland.gif
Super secret reinforced spam barrier 2.0
DemonSkye

ID: 37124
Level: 79
Posts: 2474
Score: 1084
DemonSkye [37124]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:11:43
only 40 million table rows.... pffffft.

demonskye.png

If you like something I've done on the forums send me a morphine, I'm running out!
Super secret reinforced spam barrier 2.0
darly

ID: 516241
Level: 28
Posts: 347
Score: -26
darly [516241]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:11:57
cool

11qtmdj.jpg
Super secret reinforced spam barrier 2.0
Gem
ID: 135228
Level: 28
Posts: 279
Score: 0
Gem [135228]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:13:16
Haha, was wondering about that

Animation222.gif
Super secret reinforced spam barrier 2.0
royalicious
ID: 582670
Level: 7
Posts: 2
Score: 0
royalicious [582670]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:15:15
thanks!

Super secret reinforced spam barrier 2.0
Chedburn

ID: 1
Level: 35
Posts: 7240
Score: 12650
Chedburn [1]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:16:21
only 40 million table rows.... pffffft.


Well in total theres around half a billion rows of data which need deleting.

Ched.jpg
Super secret reinforced spam barrier 2.0
Phill

ID: 362028
Level: 55
Posts: 17292
Score: 4388
HunkPhill [362028]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:17:38
Half a billion?!
Get the A-Team in

ubd9822.png

[staff edit]

join our sexy faction!
Super secret reinforced spam barrier 2.0
AnfieldKnight
ID: 304276
Level: 51
Posts: 37
Score: 1
AnfieldKnight [304276]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:19:02
i hope all goes smoothly after the deletion... wondering what database you are using..

Super secret reinforced spam barrier 2.0
-Geordie
ID: 524145
Level: 28
Posts: 3632
Score: -58
-Geordie [524145]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:19:37
In 1972 a crack team of commandos wass wrongfully accused of crimes they did'nt commit.......

Not mucf data their Ched then!?!!?



Super secret reinforced spam barrier 2.0
EmanBoy
ID: 442327
Level: 32
Posts: 643
Score: 58
EmanBoy [442327]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:26:54
thx ched

man1copyiy8.jpg
Super secret reinforced spam barrier 2.0
Agent_Orion
ID: 444067
Level: 30
Posts: 949
Score: -1
Agent_Orion [444067]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:29:09
ched love to imagine things? haha good one ched

Super secret reinforced spam barrier 2.0

ID:
Level:
Posts:
Score:
 []Edit | Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:32:41
you show that data whos the boss and delete its ass


lmao

Super secret reinforced spam barrier 2.0
Shaolin

ID: 2764
Level: 56
Posts: 1292
Score: 110
    Shaolin [2764]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:47:16
Thanks for the heads up!!!

Forever remember the good times Cydnee.

24_slash.jpg
Super secret reinforced spam barrier 2.0
JimbobBEng
ID: 27610
Level: 65
Posts: 3369
Score: 679
JimbobBEng [27610]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:51:33
Just do it in tonights downtime! no one will care!

1000_days_forum.png

Buying Stat Enhancers. Mail me your prices
Super secret reinforced spam barrier 2.0
_DarkFIRE_
ID: 446007
Level: 27
Posts: 185
Score: 1
_DarkFIRE_ [446007]Reply | Quote | Report

Posted on Thu Dec 06, 2007 08:56:32
kick that data in the balls

Fable_Signature_by_polainas9.jpg
Super secret reinforced spam barrier 2.0
Misery
ID: 115993
Level: 34
Posts: 3006
Score: -35
Misery [115993]Reply | Quote | Report

Posted on Thu Dec 06, 2007 09:27:38
Cool

Sig-one.gif
Super secret reinforced spam barrier 2.0
Dogballs

ID: 249298
Level: 46
Posts: 875
Score: 14
Dogballs [249298]Reply | Quote | Report

Posted on Thu Dec 06, 2007 09:37:49
death to data

Super secret reinforced spam barrier 2.0
MacLegend
ID: 100046
Level: 45
Posts: 119
Score: 2
MacLegend [100046]Reply | Quote | Report

Posted on Thu Dec 06, 2007 09:45:03
nice

Super secret reinforced spam barrier 2.0
SubZero44
ID: 192824
Level: 34
Posts: 2484
Score: 0
SubZero44 [192824]Reply | Quote | Report

Posted on Thu Dec 06, 2007 09:51:28
Why don't you just ctrl+a, and then ''Backspace''?o_O

Just joking lol Do whatever it takes

Forum Main>>Announcements>> Delete Script
First  << 1  2  3 >>  Last

This thread has been locked.