![]() |
|
|
#12 | |||
|
If I May
"Chris Halsall"
Sep 2002
Barbados
2·5·7·139 Posts |
Quote:
Quote:
Indeed! ![]() I've set myself a budget of no more than $150 USD a month -- approximately the same as my other habit (tobacco). Quote:
Thanks again! P.S. Oh, and so you know, I had planned on comparing the economics of g2.2xlarge vs. cg1.4xlarge. The latter is a bit less than twice the spot price (USD 0.0815 vs 0.135) currently, with a bit more than twice the GPU throughput (~240 vs 2*~280 GHzd/d), so the cg1 definitely wins. Thanks for inspiring me to drill down on What Makes (Economic) Sense! |
|||
|
|
|
|
|
#13 | ||||
|
"/X\(‘-‘)/X\"
Jan 2013
22×733 Posts |
Quote:
Quote:
Quote:
If you're using MySQL, be sure you're using the LOCK TABLE `table` WRITE; syntax. Quote:
I wrote my scripts fairly generically. They should support the g2 out of the box. I want to add a 0-50 second random delay to the work fetching to not swamp mersenne/gpu72. A little more work and I could have an AMI that could be completely configured from the user-data, so anyone could launch and participate. Given how quickly they chew through exponents, the backup component really isn't necessary, but might be desirable for 73-74 assignments. I would also like to use the CPUs, which sit idle. |
||||
|
|
|
|
|
#14 | ||
|
If I May
"Chris Halsall"
Sep 2002
Barbados
2×5×7×139 Posts |
Quote:
Quote:
Code:
DoSQLCommand("lock tables GPU write, Assigned write");
$sql = "select * from (select Exponent,FactTo from GPU where"
." Exponent>=${Low} and Exponent<=${High} and FactTo<${Pledge} and WorkTypePN=201 and Status=0 and Back=0"
." order by ${Sort} limit ${Number}) as G order by Exponent";
|
||
|
|
|
|
|
#15 | |
|
"/X\(‘-‘)/X\"
Jan 2013
B7416 Posts |
Quote:
Code:
backup:~/mfaktc_backup$ cat */worktodo.txt | sort | uniq -cd | less | sort -r
5 Factor=N/A,35253013,70,71
5 Factor=N/A,35253007,70,71
5 Factor=N/A,35252993,70,71
5 Factor=N/A,35252927,70,71
5 Factor=N/A,35252717,70,71
5 Factor=N/A,35252689,70,71
5 Factor=N/A,35252641,70,71
5 Factor=N/A,35252431,70,71
5 Factor=N/A,35252417,70,71
5 Factor=N/A,35252359,70,71
5 Factor=N/A,35252233,70,71
5 Factor=N/A,35252143,70,71
5 Factor=N/A,35252089,70,71
5 Factor=N/A,35252051,70,71
5 Factor=N/A,35252047,70,71
5 Factor=N/A,35252039,70,71
5 Factor=N/A,35251757,70,71
5 Factor=N/A,35251621,70,71
5 Factor=N/A,35251597,70,71
5 Factor=N/A,35251499,70,71
5 Factor=N/A,35251303,70,71
5 Factor=N/A,35251199,70,71
5 Factor=N/A,35251147,70,71
5 Factor=N/A,35251087,70,71
2 Factor=N/A,35253047,70,71
2 Factor=N/A,35251789,70,71
Code:
backup:~/mfaktc_backup$ cat */worktodo.txt | sort | uniq -cd | FS=',' sort -k 2
5 Factor=N/A,35251087,70,71
5 Factor=N/A,35251147,70,71
5 Factor=N/A,35251199,70,71
5 Factor=N/A,35251303,70,71
5 Factor=N/A,35251499,70,71
5 Factor=N/A,35251597,70,71
5 Factor=N/A,35251621,70,71
5 Factor=N/A,35251757,70,71
2 Factor=N/A,35251789,70,71
5 Factor=N/A,35252039,70,71
5 Factor=N/A,35252047,70,71
5 Factor=N/A,35252051,70,71
5 Factor=N/A,35252089,70,71
5 Factor=N/A,35252143,70,71
5 Factor=N/A,35252233,70,71
5 Factor=N/A,35252359,70,71
5 Factor=N/A,35252417,70,71
5 Factor=N/A,35252431,70,71
5 Factor=N/A,35252641,70,71
5 Factor=N/A,35252689,70,71
5 Factor=N/A,35252717,70,71
5 Factor=N/A,35252927,70,71
5 Factor=N/A,35252993,70,71
5 Factor=N/A,35253007,70,71
5 Factor=N/A,35253013,70,71
2 Factor=N/A,35253047,70,71
Last fiddled with by Mark Rose on 2014-06-24 at 22:37 |
|
|
|
|
|
|
#16 | |
|
If I May
"Chris Halsall"
Sep 2002
Barbados
260216 Posts |
Quote:
Code:
mysql> select * from Assigned where Exponent=35251087; +---------+----------+----------------------------------+----------+------------+--------+----------+--------+---------------------+---------------------+---------------------+---------------------+---------------------+----------+----------+----+--------------+-----------------+-----+-----+---------+-----+ | ID | Exponent | User | WorkType | WorkTypePN | Status | FactFrom | FactTo | Assigned | Updated | Completed | Adjusted | James | Extended | Factored | P1 | GHzDays | IP | CID | CPU | Percent | AID | +---------+----------+----------------------------------+----------+------------+--------+----------+--------+---------------------+---------------------+---------------------+---------------------+---------------------+----------+----------+----+--------------+-----------------+-----+-----+---------+-----+ | 1384288 | 35251087 | 0b704871bc2c1d367ffd1518c35d6e60 | 1 | 201 | 1 | 69 | 70 | 2014-06-08 23:20:16 | 0000-00-00 00:00:00 | 2014-06-12 01:21:47 | 2014-06-09 01:21:47 | 0000-00-00 00:00:00 | 0 | 0 | 0 | 3.3917772770 | 84.80.145.240 | | 0 | 0 | | | 1405044 | 35251087 | ea39a75de82cd896610be22735054fc5 | 1 | 201 | 90 | 70 | 71 | 2014-06-24 07:13:48 | 0000-00-00 00:00:00 | 2014-06-24 07:37:56 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0 | 0 | 0 | 6.7835545540 | 50.17.6.127 | | 0 | 0 | | | 1405226 | 35251087 | ea39a75de82cd896610be22735054fc5 | 1 | 201 | 90 | 70 | 71 | 2014-06-24 08:27:58 | 0000-00-00 00:00:00 | 2014-06-24 08:56:44 | 0000-00-00 00:00:00 | 0000-00-00 00:00:00 | 0 | 0 | 0 | 6.7835545540 | 50.19.167.195 | | 0 | 0 | | | 1405425 | 35251087 | ea39a75de82cd896610be22735054fc5 | 1 | 201 | 1 | 70 | 71 | 2014-06-24 09:59:58 | 0000-00-00 00:00:00 | 2014-06-24 11:22:34 | 2014-06-24 11:22:34 | 0000-00-00 00:00:00 | 0 | 0 | 0 | 6.7835545540 | 174.129.137.188 | | 0 | 0 | | +---------+----------+----------------------------------+----------+------------+--------+----------+--------+---------------------+---------------------+---------------------+---------------------+---------------------+----------+----------+----+--------------+-----------------+-----+-----+---------+-----+ |
|
|
|
|
|
|
#17 | |
|
"/X\(‘-‘)/X\"
Jan 2013
22·733 Posts |
Quote:
Code:
SELECT COUNT(g.Exponent) FROM GPU g LEFT JOIN Assigned a ON g.Exponent = a.Exponent AND g.FactTo <= a.FactTo AND g.Status != a.Status WHERE g.Exponent > 35000000 AND g.Exponent < 36000000 AND g.WorkTypePN=201 and g.Status=0 and g.Back=0 I've run into issues with innodb_rollback_on_timeout being set to OFF (default) before. |
|
|
|
|
|
|
#18 |
|
If I May
"Chris Halsall"
Sep 2002
Barbados
2·5·7·139 Posts |
|
|
|
|
|
|
#19 |
|
"/X\(‘-‘)/X\"
Jan 2013
293210 Posts |
|
|
|
|
|
|
#20 | |
|
If I May
"Chris Halsall"
Sep 2002
Barbados
260216 Posts |
Quote:
All I can tell you (again) is I don't think the code on GPU72 did you wrong. Happy to be proven wrong. |
|
|
|
|
|
|
#21 |
|
"/X\(‘-‘)/X\"
Jan 2013
1011011101002 Posts |
|
|
|
|
|
|
#22 |
|
"/X\(‘-‘)/X\"
Jan 2013
22·733 Posts |
I must apologize for all the trouble. I had one stale file that I missed deleting that was causing the problem.
Everything is working perfectly. I'm sorry. |
|
|
|
![]() |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Let GPU72 Decide and other questions | jschwar313 | GPU to 72 | 11 | 2016-10-14 19:16 |
| Factor not recorded by GPU72 | bayanne | GPU to 72 | 24 | 2014-05-16 09:20 |
| GPU72 out of 332M exponents? | Uncwilly | GPU to 72 | 16 | 2014-04-11 11:31 |
| Cooperative Agreement or Capitalist Takeover? You decide! | cheesehead | Lounge | 97 | 2013-11-16 21:19 |
| GPU72.COM is down | swl551 | GPU to 72 | 1 | 2013-01-11 12:54 |