Hello Mustafa -
You should run "top", "vmstat", iostat" or whatever other process monitoring
tool you prefer to see how the machine is performing. Once you have verified
that it is in fact the mysqld process that is using all of the resources of
the machine, you should look at the indexes on the database and consult the
MySQL tuning documentation. Once you have done that you may have to look at
throwing more hardware at it - multiple processors, very fast 15,000 RPM SCSI
disks, fast SCSI controller(s), etc.
hth
Hugh
On Tuesday 01 May 2001 20:02, Mustafa Mal wrote:
> 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
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.
