Hi Hugh,
I am using MySQL for the database. The SQL timeout does not occur
regularly but on the weekends when the traffic is at its peak.
Is this problem due to the excessive queries ? There are around
500,000 records in the Authentication Database.
Can you suggest how can I investigate the timeout. And how can this be
rectified?
Thanks for your reply.
Mustafa
----- Original Message -----
From: "Hugh Irvine" <[EMAIL PROTECTED]>
To: "Mustafa Mal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, 01 May 2001 12:49 AM
Subject: Re: (RADIATOR) RADONLINE Crashing
Hello Mustafa -
The log message below shows that your SQL server is timing out and Radiator
is marking it down and waiting some period of time before trying to use it
again. You will have to investigate why the SQL server is so busy that it
is
not able to respond to any queries.
regards
Hugh
On Monday 30 April 2001 23:41, Mustafa Mal wrote:
> Hi Hugh,
>
> I am having a strange problem. The number of users on the RADONLINE
> drops suddenly when the router is at peak capacity and there are about
> 1100 users online.
>
> This usually happens during the weekend when the traffic is at its
> peak. I have checked the logs (trace level 2) and got the following
> entries.
>
>
>
> Fri Apr 27 02:00:36 2001: ERR: do failed for 'delete from RADONLINE
> where NASIDENTIFIER='195.39.142.13' and NASPORT=0267': SQL Timeout
>
>
> I am using the standard dictionary and we have Tigris as well as
> Cisco routers
>
>
> Please advice
>
> Mustafa
>
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
