Read the documentation that came with MySQL... it talks about just this senario and what to do about it. There is a perl script that can be used to perform a Hot-Database dump without causing the table to be locked during the dump operation. The script is also discussed (look in database backup operations section of MySQL documentation for details)... Gary N. McKinney
Network Administrator Computer Services Dept. Brevard County Library System ---------- Original Message ---------------------------------- From: "jesk" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 21 Jul 2004 05:49:16 +0200 >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 >--- >[This E-mail scanned for viruses by Declude Ant-Virus Scanner] > > ________________________________________________________________ Sent via the KillerWebMail system at mail.brev.org - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
