Deadlocks in Freeradius MySQL Database

[Alan DeKok]

On Nov 4, 2017, at 8:45 AM, Claudio Carvalho <claudio at nextdigitalservices.com.br> wrote:
> I am testing freeradius version 3 with RedHat Enterprise Server 7.4 and MySQL 5.6.35, even in a newly fresh/initialized database I get these messages in radius.log, has anyone else been through this situation yet?

  Yes.  MySQL isn't really the best choice.  When FreeRADIUS tries to grab one IP address, MySQL locks the entire table.  This isn't the best approach...

> what would be the best choice of operating system, database and freeradius version that recommend as more stable?

  PostgreSQL won't have this problem.  It has row-level locks.

  Alan DeKok.