Hi

Did you try to open database and see all tables and data inside them? Maybe one of the tables is damaged so you'll need to check it first (and repair if it is necessary) .

Egi wrote:
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!


[EMAIL PROTECTED] 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



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


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

Reply via email to