mersenneforum.org

mersenneforum.org (https://www.mersenneforum.org/index.php)
-   No Prime Left Behind (https://www.mersenneforum.org/forumdisplay.php?f=82)
-   -   Team drive #13: k=400-600 n=1M-2M (https://www.mersenneforum.org/showthread.php?t=15917)

mdettweiler 2012-09-02 15:55

[QUOTE=AMDave;310020]I just optimized the database tables for that port now the range is removed.
should be a touch quicker.[/QUOTE]
Excellent, thanks! (Wow, it loads fast--I just pulled up [url]http://noprimeleftbehind.net:9000/all.html[/url] in half a second flat! :w00t:)

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... :rolleyes:

AMDave 2012-09-02 20:09

email sent

henryzz 2012-09-02 21:11

[QUOTE=AMDave;310068]email sent[/QUOTE]
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.

CGKIII 2012-09-03 05:50

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.

mdettweiler 2012-09-03 16:59

[QUOTE=CGKIII;310112]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.[/QUOTE]
It turns out it's pretty simple: just run "optimize table [I]table[/I];" 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.)

henryzz 2012-09-18 10:24

Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?

kar_bon 2012-09-18 11:13

[QUOTE=henryzz;312069]Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?[/QUOTE]

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.

gd_barnes 2012-09-18 18:18

[QUOTE=henryzz;312069]Is there any particular reason why drive 13 is so far behind drive 14 even though it is easier and has lower ks?[/QUOTE]

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 2012-09-22 07:25

Reserving n=1160K-1200K for port 9000.

gd_barnes 2013-03-30 18:59

I seem to be searching all the primeless ranges on this drive so that everyone else can find the primes. :no: 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.

MyDogBuster 2013-03-30 19:43

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


All times are UTC. The time now is 11:36.

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