mersenneforum.org  

Go Back   mersenneforum.org > Prime Search Projects > No Prime Left Behind

Reply
 
Thread Tools
Old 2012-09-02, 15:55   #23
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

3·2,083 Posts
Default

Quote:
Originally Posted by AMDave View Post
I just optimized the database tables for that port now the range is removed.
should be a touch quicker.
Excellent, thanks! (Wow, it loads fast--I just pulled up http://noprimeleftbehind.net:9000/all.html in half a second flat! )

BTW, how does one go about optimizing the tables (what commands, etc.)? You've probably told me before but I can't recall it for the life of me...

Last fiddled with by mdettweiler on 2012-09-02 at 15:56
mdettweiler is offline   Reply With Quote
Old 2012-09-02, 20:09   #24
AMDave
 
AMDave's Avatar
 
Jan 2006
deep in a while-loop

65810 Posts
Default

email sent
AMDave is offline   Reply With Quote
Old 2012-09-02, 21:11   #25
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT)

130208 Posts
Default

Quote:
Originally Posted by AMDave View Post
email sent
I am afraid max isn't the only one interested. Am I right in thinking that optimising the tables after adding a rediculous amount of candidates is just as helpful as doing it after deleting them? I created a server recently with too many candidates and it took ages to respond to the client.
henryzz is offline   Reply With Quote
Old 2012-09-03, 05:50   #26
CGKIII
 
Aug 2012

52 Posts
Default

Similar request for info. I started my personal server with ~1000 k's at n = 2500, originally loaded with a bit over a million candidate tests. I've gotten it down to 500,000 due to a lot of messy SQL (and completing tests / finding primes), but it would be awesome to get some better code. Of course, next time I'll narrow things down a bit more first.
CGKIII is offline   Reply With Quote
Old 2012-09-03, 16:59   #27
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

3·2,083 Posts
Default

Quote:
Originally Posted by CGKIII View Post
Similar request for info. I started my personal server with ~1000 k's at n = 2500, originally loaded with a bit over a million candidate tests. I've gotten it down to 500,000 due to a lot of messy SQL (and completing tests / finding primes), but it would be awesome to get some better code. Of course, next time I'll narrow things down a bit more first.
It turns out it's pretty simple: just run "optimize table table;" for each table in the database. (I'm assuming you already know the basics of getting in and navigating through an SQL database, since you were able to clean out old tests from your server.)
mdettweiler is offline   Reply With Quote
Old 2012-09-18, 10:24   #28
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT)

24×353 Posts
Default

Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?
henryzz is offline   Reply With Quote
Old 2012-09-18, 11:13   #29
kar_bon
 
kar_bon's Avatar
 
Mar 2006
Germany

2,767 Posts
Default

Quote:
Originally Posted by henryzz View Post
Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?
Because there's more activity on Drive 14 (Port 2000) than on Drive 13 (Port 9000):

the last days there were ~300 paris done on Port 2000 but only ~30 on Port 9000.
End of August the difference in pairs was much higher.
kar_bon is offline   Reply With Quote
Old 2012-09-18, 18:18   #30
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

23×439 Posts
Default

Quote:
Originally Posted by henryzz View Post
Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?
We had two rallies on drive 14 when it was behind drive 13. Then a big cruncher stayed on drive 14 for a long time afterwords. Our next rally will be on drive 13.
gd_barnes is offline   Reply With Quote
Old 2012-09-22, 07:25   #31
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

23×439 Posts
Default

Reserving n=1160K-1200K for port 9000.
gd_barnes is offline   Reply With Quote
Old 2013-03-30, 18:59   #32
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

23·439 Posts
Default

I seem to be searching all the primeless ranges on this drive so that everyone else can find the primes. There's been one prime in the last n=23K range; by far the worst range since the drive started. I wonder if all of my machines have gone bad at once.
gd_barnes is offline   Reply With Quote
Old 2013-03-30, 19:43   #33
MyDogBuster
 
MyDogBuster's Avatar
 
May 2008
Wilmington, DE

2×13×109 Posts
Default

Quote:
There's been one prime in the last n=23K range; by far the worst range since the drive started.
Probably setting up for a nice run shortly.

Last fiddled with by MyDogBuster on 2013-03-30 at 20:12 Reason: Spelling
MyDogBuster is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Team drive #6 k=600-800 n=600K-1M gd_barnes No Prime Left Behind 89 2011-03-10 12:34
Team drive #5: k=400-600 n=600K-1M gd_barnes No Prime Left Behind 135 2010-11-23 14:27
Team drive #4, 15 k's < 300 for n=600K-1M gd_barnes No Prime Left Behind 38 2008-10-22 16:20
Opinions on team drive #3 gd_barnes Conjectures 'R Us 8 2008-01-24 01:01
Don't Miss The First RPS Team Drive! Kosmaj Riesel Prime Search 451 2007-07-08 21:06

All times are UTC. The time now is 15:58.

Mon Apr 6 15:58:35 UTC 2020 up 12 days, 13:31, 2 users, load averages: 1.65, 1.94, 1.98

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, 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.