I cant get testnet3 blockchain to sync with bitcoinj as a mysqlfullprunedblockstore. It works fine with regtest (a lot less blocks ofcourse). I think this has to do with mysqlblockstore and there is a bottleneck somewhere.
As i understand it, i have to store all headers and prune the undoableblocks like 1000 blocks back. but when i sync the chain im pulling all transactions from every block i get, this means im verifying billions of transactions. My blocks per second drops to 1 (or .1 /s )sporadically through the sync for what seems like hours at a time before going back up. at this rate it will take 3.6 years to complete the sync. my network is fine, and when bitcoinj allows it i can pull 100 blocks /s when its not running 1000 getUnspent() queries per block. Clearly this is done to verify transactions, but lets say i trust my peers, like if i download through bitcoind then sync with a local bitcoind peer at all times instead of direct to other peers. can i disable verification? i tested with shouldVerifyTransactions() false (just rebuilt from source with return false;) but i just get a train of errors about a mile long due to not having transactions in the storedundoableblock (which shouldnt even be added?), im so many errors deep now im not going down that rabbit hole, full pruned block chain is written around verifying transactions. So how can i sync 1.4 million blocks if im getting < 2 b/s at times, if i cant turn off verification? should i move away from mysqlFullPrunedBlockStore? note, i also get spontaneous failures and have to restart the peergroup, on top of the horrible speed impacts. I turned off expensiveChecks in abstractBlockChain, it didnt help any. any idea what i can do here to make this sync somewhat possible? is this speed intended? BITCOIN J LOG: https://pastebin.com/RjmfGTGR MYSQL QUERY LOG: this is at the time it failed, notice the large number of SELECT queries, i get 1000s of SELECT chainwork or SELECT COUNT(*) undoableBlock for every block downloaded when it slows. sorry to post to pastebin but google couldnt handle the logs. https://pastebin.com/JqVmD2Xn Thank you so much for all of your help so far. -- You received this message because you are subscribed to the Google Groups "bitcoinj" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
