Hi, before deleting all sessions in the radacct table in mysql4.0 which are older than one day these sessions were dumped to another session database. in this timespan every freeradius thread which will process a statement hangs with a LOCK state, shown by show processlist in mysql. these sql connections from freeradius which are idleing in this time will very fast fill up with hundred of locked statements. until the dump and the delete statement is finished, the freeradius mysql processes are hanging in the LOCK state and arent processed. im not really sure, why a simple delete statement with an extra of low_priority or the mysqldump without any locking argument will cause an lock of the whole table. could there the possibility that freeradius are having problems in somehow or other. i dont know what could be the problem. the mysqlserver is running on FreeBSD5-Current and was compiled with kse pthreads. also i tested it under 5.2.1-Release with linuxthreads but with the same result. iam very surprised of the problem and even dont know if iam asking on the right mailinglist for this kind of question ;)
thanks for any hints. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
