This graph at Pool-X (LiteCoin pool) is really nice. I think you have to login to see it, but I think seeing it is worth making an account.
http://pool-x.eu/blocksAuthIt is a nice graph. It is per block and not per time though, on the X-axis, so it's basically the same as ours. But the Y-axis is number of shares instead of CDF, and they have a running average for the pool shown in addition to each individual block. Might be an idea adding such an average. Not sure about shares vs. CDF though.
DrHaribo did you change anything on the server lately?
Yeah, I changed most of the database stuff in the pool backend. I put in some stuff to make parallel updates safe and added automatic retries in case a database operation fails.
1) some rows are missing from my blocks list: 657, 659-660, 662, 669, 671-687, 689-691, 693, 695-698, 701-702, 705-706, 712
That's due to parallel database transactions conflicting and one being rolled back and retried. When a database transaction is rolled back everything you did is reset to how it was before the transaction started
except sequences. When a number is allocated from a sequence the same number won't be given out again, even after a rollback. Already there are many gaps in the user IDs. Now with the new database code there are gaps in the block numbers. Looks a bit ugly.
I think maybe I'll switch to not showing the internal ID. The table is also sometimes too wide, so that may help with that problem. Or is a block ID of some sort useful?
2) BTC blocks and NMC blocks don't come anymore in pairs as earlier:
- when BTC block 170048 was found (row 661) NMC block 45862 is listed 1 minute earlier (row 658)
- when BTC block 170495 was found (row 688) NMC block 46281 is listed 5 minutes earlier (row 670)
- when BTC block 170638 was found (row 699) NMC block 46403 is listed 1 minute earlier (row 694)
- when BTC block 170759 was found (row 710) there is no NMC block listed mined by the same user near by
- when the last BTC block 170838 was found (row 713) there is NMC block 46572 found by the same user 5.5 hrs earlier (row 711)
170838 was stale on the NMC side unfortunately. I checked the logs and we received a new namecoin block from the namecoin P2P network 5 seconds before we attempted to create ours. Let's just be glad that was a new NMC block just ahead of ours, and not a BTC block.
170495 and 46281 were created from a single proof of work from kjakman. They were created at the same time, but one had trouble getting registered in the database. It took a full 5 minutes from it was created until it was successfully registered in the DB. I was watching and cursing as the database transactions were being retried.
Also this database code is putting 10x to 20x the load on the database, compared to earlier. While that's not a problem for the server, I don't like it. I am already working on a new solution that should run much smoother. On my test server the load was much lower and conflicting transactions happened very rarely. Back to the drawing board!