Unable to acquire database lock error occurs frequently

[ety001]

Due to the lack of performance tuning of RocksDB, the current ahnode api performance is seriously insufficient.

Now we have set redis cache to -2 (cached without expiration only if it is irreversible in terms of blockchain consensus) for get_ops_in_block and get_transaction api except the get_account_history api.

But lots of get_account_history(username, -1, 10000) requests pass through ahnode.
The large range query will seriously slow down ahnode performance because locks are frequently generated.
That's why the steemitwallet.com is not stable in this two weeks.
The wallet service and ahnode apis are deeply coupled. When the ahnode api goes down, the wallet will give out a 504 error.

So we plan to reduce the get_account_history limit from 10000 to 100 in jussi layer. That means get_account_history api from official api will only return up to 100 pieces of data.

The change will take effect at 2022-07-06 13:00:00 (UTC+8) .