Hello, I tried to optimize tables, and also followed the sql tunning guide by setting the database to innodb but I still get only these error: Sun Jul 6 17:32:28 2008 : Error: Dropping conflicting packet from client mikrotik1:43365 - ID: 45 due to unfinished request 22668 Sun Jul 6 17:32:28 2008 : Error: Dropping conflicting packet from client mikrotik2:54058 - ID: 250 due to unfinished request 22681 Thank You! A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Mikrotik Router > freeradius server > Mysql Server
From time to time (Maybe once in 4-5 days) i get this error repeated for many many times:
your MySQL is too slow to respond to the requests - check your SQL queries and see how you can optimise them. I've been able to go from queries that look up many thousands of lines to just a single index query. change your MySQL engine to InnoDB - or even better, move to postgresql instead. these event happen when a table gets eventually too large for the basic MySQL settings to cope. think about deleting old records etc. i
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html