3 Jul
2008
3 Jul
'08
2:23 p.m.
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