Quote from: fibble on September 13, 2011, 06:01:51 PM

I have been mining with this pool through 3+ blocks now and my BTC balance is still at 0BTC despite having submitted 100's or 1000's of shares in each of these 3+ rounds.

Is this just slow database?

Andy

We are 3 block behind and here is what it does ever 7 minutes.

Code:

cron
immature = 21
orphan = 0
total time to run nmc_RPC_UpdateBlockInfo = 1
Doing Pool Stat updates...
Runnig worker stat updates...
Worker stat update executed in 16 seconds.
Executing code to update all user balances.
Updating nmc_balance for user user 32 nmc_block 142602 result = 2
Updating nmc_balance for user user 31 nmc_block 142602 result = 2
Updating nmc_balance for user user 113 nmc_block 142602 result = 2
Updating nmc_balance for user user 5 nmc_block 142602 result = 2
Updating nmc_balance for user user 96 nmc_block 142602 result = 2
Updating nmc_balance for user user 120 nmc_block 142602 result = 2
Updating nmc_balance for user user 87 nmc_block 142602 result = 2
Updating nmc_balance for user user 12 nmc_block 142602 result = 2
Updating nmc_balance for user user 14 nmc_block 142602 result = 2
Updating nmc_balance for user user 73 nmc_block 142602 result = 2
Updating nmc_balance for user user 101 nmc_block 142602 result = 2
Updating nmc_balance for user user 49 nmc_block 142602 result = 2
Updating nmc_balance for user user 44 nmc_block 142602 result = 2
Updating nmc_balance for user user 35 nmc_block 142602 result = 2
Updating nmc_balance for user user 124 nmc_block 142602 result = 2
Updating nmc_balance for user user 109 nmc_block 142602 result = 2
Updating nmc_balance for user user 22 nmc_block 142602 result = 2
Updating nmc_balance for user user 85 nmc_block 142602 result = 2
Updating nmc_balance for user user 71 nmc_block 142602 result = 2
Updating nmc_balance for user user 82 nmc_block 142602 result = 2
Updating nmc_balance for user user 68 nmc_block 142602 result = 2
Updating nmc_balance for user user 18 nmc_block 142602 result = 2
Updating nmc_balance for user user 90 nmc_block 142602 result = 2
Updating nmc_balance for user user 1 nmc_block 142602 result = 2
Updating nmc_balance for user user 9 nmc_block 142602 result = 2
Updating nmc_balance for user user 98 nmc_block 142602 result = 2
Updating nmc_balance for user user 37 nmc_block 142602 result = 2
Updating nmc_balance for user user 13 nmc_block 142602 result = 2
Updating nmc_balance for user user 28 nmc_block 142602 result = 2
Updating nmc_balance for user user 81 nmc_block 142602 result = 2
Updating nmc_balance for user user 102 nmc_block 142602 result = 2
Updating nmc_balance for user user 21 nmc_block 142602 result = 2
Updating nmc_balance for user user 19 nmc_block 142602 result = 2
Updating nmc_balance for user user 20 nmc_block 142602 result = 2
Updating nmc_balance for user user 42 nmc_block 142602 result = 2
Updating nmc_balance for user user 63 nmc_block 142602 result = 2
Updating nmc_balance for user user 75 nmc_block 142602 result = 2
Updating nmc_balance for user user 106 nmc_block 142602 result = 2
Updating nmc_balance for user user 126 nmc_block 142602 result = 2
Updating nmc_balance for user user 86 nmc_block 142602 result = 2
Updating nmc_balance for user user 53 nmc_block 142602 result = 2
Updating nmc_balance for user user 105 nmc_block 142602 result = 2
Updating nmc_balance for user user 91 nmc_block 142602 result = 2
Updating nmc_balance for user user 70 nmc_block 142602 result = 2
Updating nmc_balance for user user 52 nmc_block 142602 result = 2
Updating nmc_balance for user user 62 nmc_block 142602 result = 2
Updating nmc_balance for user user 11 nmc_block 142602 result = 2
Updating nmc_balance for user user 111 nmc_block 142602 result = 2
Updating nmc_balance for user user 107 nmc_block 142602 result = 2
Updating nmc_balance for user user 47 nmc_block 142602 result = 2
Updating nmc_balance for user user 27 nmc_block 142602 result = 2
Updating nmc_balance for user user 24 nmc_block 142602 result = 2
Updating nmc_balance for user user 65 nmc_block 142602 result = 2
Updating nmc_balance for user user 58 nmc_block 142602 result = 1
Updating nmc_balance for user user 127 nmc_block 142602 result = 1
Updating nmc_balance for user user 61 nmc_block 142602 result = 1
Updating nmc_balance for user user 15 nmc_block 142602 result = 1
Updating nmc_balance for user user 114 nmc_block 142602 result = 1
Updating nmc_balance for user user 54 nmc_block 142602 result = 1
Total number of users to update = 120 Users updated and double checked = 53 time took = 37

If I increase the time to do this you will not be able to insert shares. MySql is not Microsoft SQL server. I have to work around it's short comings. Also on Amazon servers if you are using the cpu at 100% to long they throttler you down making the process even slower crushing the pushpools ability to insert shares.

I have a large server with 8 gigs of ram 2 CPUs for MySQL (anything bigger is did not help MySQL only uses one CPU) also I have another server called conserver5.nmcbit.com no one is on that execept me with 29 Mhs and I still get...

Code:

2011-09-13 14:25:21: Listener for "coinserver5 test": 13/09/2011 14:25:21, Problems communicating with bitcoin RPC 0 2

Without clustering MySQL like I have clustered pushpool/namecoin/bitcoin there is no way that I know of I can accept shares faster than 25 GHs without problems.

If anyone has any suggestions that will be quick to implement I'm all ears.