RES: Deadlocks in Freeradius MySQL Database

[Claudio Carvalho]

Thank you Alan.

Claudio Carvalho

-----Mensagem original-----
De: Freeradius-Users [mailto:freeradius-users-bounces+claudio=nextdigitalservices.com.br at lists.freeradius.org] Em nome de Alan DeKok
Enviada em: sábado, 4 de novembro de 2017 11:42
Para: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Assunto: Re: Deadlocks in Freeradius MySQL Database

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.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html