Hello!

Tried Clear history and trends for several elements,
it results in:

[Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [insert into history (itemid,clock,ns,value)

Looks like delete query takes too long and, thus, blocks tables.

I guess I may need some database tuning, but, is it possible to do something to reduce block time, f.e. split queries from one to several?

Thank you!