Big wallet, Flushing wallet.dat is quite slow

[007pig]

I have a wallet with many transactions. It's around 200M. and each wallet flushing takes 4 seconds and blocks JSON RPC calls.

I think it should be improved.

[sipa]

Agree, this is a problem. It will likely be fixed when we move to non-BDB wallets.

[sipa]

Agree, this is a problem. It will likely be fixed when we move to non-BDB wallets.

[007pig]

When will it happen do you know?

[007pig]

When will it happen do you know?

[007pig]

CTxMemPool::accept() : accepted 8a01e91659 (poolsz 691)
ThreadRPCServer method=move
CTxMemPool::accept() : accepted 954115b276 (poolsz 692)
Flushed wallet.dat 5071ms
ThreadRPCServer method=getreceivedbyaddress
ThreadRPCServer method=getbalance
CTxMemPool::accept() : accepted 542b3860e4 (poolsz 693)
ThreadRPCServer method=listtransactions
Flushing wallet.dat
CTxMemPool::accept() : accepted 0b274c1c36 (poolsz 694)
Added 2 addresses from 68.119.78.5: 239 tried, 15033 new
CTxMemPool::accept() : accepted 24ca9ce2e4 (poolsz 695)
ThreadRPCServer method=move
Flushed wallet.dat 4546ms

You can see that the wallet.dat is keeping flushed and slow down everything. Can we make the flushing not so frequently? Can I increase 'dbcache' to speed it up?

[007pig]

CTxMemPool::accept() : accepted 8a01e91659 (poolsz 691)
ThreadRPCServer method=move
CTxMemPool::accept() : accepted 954115b276 (poolsz 692)
Flushed wallet.dat 5071ms
ThreadRPCServer method=getreceivedbyaddress
ThreadRPCServer method=getbalance
CTxMemPool::accept() : accepted 542b3860e4 (poolsz 693)
ThreadRPCServer method=listtransactions
Flushing wallet.dat
CTxMemPool::accept() : accepted 0b274c1c36 (poolsz 694)
Added 2 addresses from 68.119.78.5: 239 tried, 15033 new
CTxMemPool::accept() : accepted 24ca9ce2e4 (poolsz 695)
ThreadRPCServer method=move
Flushed wallet.dat 4546ms

You can see that the wallet.dat is keeping flushed and slow down everything. Can we make the flushing not so frequently? Can I increase 'dbcache' to speed it up?

[Diapolo]

AFAIK that Wallet flush thread was introduced by @gavinandresen the way it is currently working with Git master, perhaps we need to re-think how often the wallet is flushed, dunno not my playground ^^.

[Diapolo]

AFAIK that Wallet flush thread was introduced by @gavinandresen the way it is currently working with Git master, perhaps we need to re-think how often the wallet is flushed, dunno not my playground ^^.

[gmaxwell]

I believe this is currently fixed in master.

[gmaxwell]

I believe this is currently fixed in master.