Re: Locked queries

[Peter Brawley]

MySQL version? RAM?

Have you worked through suggestions in https://www.percona.com/blog/2013/09/20/innodb-performance-optimization-basics-updated/ (or similar) ? If so and the problem persists ...

Are these updates Update commands? Load Data? Batched? In transaction blocks? Is the table referenced by foreign keys?

Let's see results of ...

Show Create Table radacct;
show table status like 'radacct';
show variables like '%innodb%';