josem
The only things I can think of is the typical stuff like non-optimized MySQL, not enough resources dedicated to MySQL, maybe you have a database dump command running often that’s locking the table, etc.
I would suggest converting to InnoDB however due to the nature of the data you’ll see it’s not easy.
Cheers.
