mersenneforum.org  

Go Back   mersenneforum.org > Fun Stuff > Lounge

Reply
 
Thread Tools
Old 2016-05-20, 22:55   #23
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

22·7·227 Posts
Default

Quote:
Originally Posted by Madpoo View Post
The whole thing compressed down (indexes and all) is something like 20 GB for a full backup (that's using the built-in SQL compression option).
Built-in SQL compression doesn't typically do much. I know it does nothing on Oracle. Can you export un-compressed then use 7zip? I would be surprised if it isn't less than 10G.
rogue is online now   Reply With Quote
Old 2016-05-21, 05:29   #24
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

3,313 Posts
Default

Quote:
Originally Posted by rogue View Post
Built-in SQL compression doesn't typically do much. I know it does nothing on Oracle. Can you export un-compressed then use 7zip? I would be surprised if it isn't less than 10G.
I don't know about Oracle, but MSSQL's internal compression isn't too bad. I'd compare it to a low level of zlib, like a level 3 out of 10. Fast enough to be useful and compresses enough to get what would normally be 70 GB down to just 20 GB.

I'm sure 7z or RAR could do much better but that would mean doing a full size backup and compressing separately which would take a lot of time... the extra time to shrink by another 5 GB (just an example) would probably not be made up in less time to back it up to the cloud, and bandwidth isn't really an issue.

There are some 3rd party MSSQL plugins out there that give you more backup compression options like setting the compression level and have a better method, but they're not free.
Madpoo is offline   Reply With Quote
Old 2016-10-10, 23:17   #25
ixfd64
Bemusing Prompter
 
ixfd64's Avatar
 
"Danny"
Dec 2002
California

96116 Posts
Default

I realize this thread is pretty old, but I have a few questions.

1. Anyone know how much of the results were salvaged from user-submitted log files?
2. Was the project insured?

I know that payouts from data loss tend to be pretty low - like tens of thousands of dollars at most - but that's still better than no compensation.

Last fiddled with by ixfd64 on 2016-10-10 at 23:20
ixfd64 is online now   Reply With Quote
Old 2016-11-06, 19:33   #26
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

143248 Posts
Default

I just saw this get posted over at Yahoo groups:

Congrats to Szabolcs Péter and PrimeGrid and Seventeen or Bust for the 9,383,761 decimal digits prime:

10223 * 2^31172165 + 1 ( http://primes.utm.edu/primes/page.php?id=122473 )

5 "k" remain in order to prove John Selfridge's conjecture,
rogue is online now   Reply With Quote
Old 2016-11-08, 06:48   #27
LaurV
Romulan Interpreter
 
LaurV's Avatar
 
Jun 2011
Thailand

26·151 Posts
Default

Quote:
Originally Posted by rogue View Post
I just saw this get posted over at Yahoo groups:

Congrats to Szabolcs Péter and PrimeGrid and Seventeen or Bust for the 9,383,761 decimal digits prime:

10223 * 2^31172165 + 1 ( http://primes.utm.edu/primes/page.php?id=122473 )

5 "k" remain in order to prove John Selfridge's conjecture,
Dang! Congrats! For the first time in years, the top10 list is not "all gimps and mersenne" anymore...
LaurV is offline   Reply With Quote
Old 2016-11-08, 07:20   #28
Jean Penné
 
Jean Penné's Avatar
 
May 2004
FRANCE

24416 Posts
Default

Quote:
Originally Posted by rogue View Post
I just saw this get posted over at Yahoo groups:

Congrats to Szabolcs Péter and PrimeGrid and Seventeen or Bust for the 9,383,761 decimal digits prime:

10223 * 2^31172165 + 1 ( http://primes.utm.edu/primes/page.php?id=122473 )

5 "k" remain in order to prove John Selfridge's conjecture,
Many congrats for this splendid result!
I am so happy to know about that!
Jean
Jean Penné is offline   Reply With Quote
Old 2016-11-08, 07:21   #29
0PolarBearsHere
 
0PolarBearsHere's Avatar
 
Oct 2015

2·7·19 Posts
Default

That needs to be fixed. Quick someone find M50->M54.
0PolarBearsHere is offline   Reply With Quote
Old 2016-11-08, 08:03   #30
LaurV
Romulan Interpreter
 
LaurV's Avatar
 
Jun 2011
Thailand

26×151 Posts
Default

Quote:
Originally Posted by 0PolarBearsHere View Post
That needs to be fixed. Quick someone find M50->M54.
LaurV is offline   Reply With Quote
Old 2016-11-08, 12:49   #31
Mark Rose
 
Mark Rose's Avatar
 
"/X\(‘-‘)/X\"
Jan 2013

2×5×293 Posts
Default

Now I'm happy to have put in lots of CPU time clearing exponents for that k :)
Mark Rose is offline   Reply With Quote
Old 2016-11-08, 19:05   #32
ixfd64
Bemusing Prompter
 
ixfd64's Avatar
 
"Danny"
Dec 2002
California

74 Posts
Default

Quote:
Originally Posted by rogue View Post
I just saw this get posted over at Yahoo groups:

Congrats to Szabolcs Péter and PrimeGrid and Seventeen or Bust for the 9,383,761 decimal digits prime:

10223 * 2^31172165 + 1 ( http://primes.utm.edu/primes/page.php?id=122473 )

5 "k" remain in order to prove John Selfridge's conjecture,
That is excellent news. I hope this renews interest in the project. Given enough contributors, I'm confident that Seventeen or Bust will recover from the data loss, especially with Moore's law on our side.
ixfd64 is online now   Reply With Quote
Old 2016-11-09, 16:49   #33
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT/BST)

133778 Posts
Default

Quote:
Originally Posted by ixfd64 View Post
That is excellent news. I hope this renews interest in the project. Given enough contributors, I'm confident that Seventeen or Bust will recover from the data loss, especially with Moore's law on our side.
It could barely have come at a better time.
henryzz is online now   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seventeen or Bust drive philmoore Lounge 6 2014-05-26 23:10
Good News Flatlander Lounge 5 2011-04-28 20:47
Seventeen or Bust finds a missed prime! VJS Lounge 3 2005-10-20 05:55
Seventeen or Bust found a prime! Mystwalker Math 5 2005-01-04 17:00
Seventeen or Bust finds Sixth Prime! wblipp Lounge 4 2003-12-16 21:08

All times are UTC. The time now is 23:22.


Fri Aug 6 23:22:11 UTC 2021 up 14 days, 17:51, 1 user, load averages: 3.92, 4.03, 4.03

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.