(RADIATOR) MySQL problem

[Leon Oosterwijk]

Deen, 

We were having problems with our RADONLINE table as well. It was stable
and would work until we had a hard mysql shutdown. The table just would
never survive a mysql kill or a sudden server reboot. As first I thought
the system was just in the middle of a write when the shutdown happened
and this was causing file corruption. However the problem persisted
after we switched to a journaled file system. Turns out the amount of
activity on the RADONLINE table was causing a LOT of delete and inserts.
All of this was cluttering up the table making it HUGE eventhough at any
given point there were only a few entries in the table. We started a
cron that repairs the table every night. This seems to have stopped the
table instability. 

# now optimize the radpool and radonline tables after a hard day's work
20 3 * * * root /usr/bin/mysql -u **** -h ******.isdn.net -p*****
radadmin -e 'OPTIMIZE TABLE RADONLINE;' > /dev/null2>&1
30 3 * * * root /usr/bin/mysql -u **** -h ******.isdn.net -p*****
radadmin -e 'OPTIMIZE TABLE RADPOOL;'   > /dev/null2>&1


Sincerely, 

Leon Oosterwijk
ISDN-NET Inc. 
(615) 221-4200
http://www.isdn.net
 

> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au] 
> Sent: Wednesday, September 04, 2002 12:48 AM
> To: deen at slt.lk; Shirantha Peiris
> Cc: radiator at open.com.au
> Subject: Re: (RADIATOR) MySQL problem
> 
> 
> 
> Hello Deen -
> 
> I have already replied to this mail, however I will resend it now.
> 
> regards
> 
> Hugh
> 
> 
> 
> > Subject: MySQL problem
> > Cc: shanp at slt.lk
> >
> > Hi,
> >
> > We are a licenced user of Radiator-2.19 with MySQL 3-22-25 
> running on an
> > i386 machine with Sun Solaris 2.7 OS.
> >
> > We have been using this product for the last 6 months without any 
> > problems
> > but recently started giving problems where we noticed that 
> the mysql 
> > server
> > crashes and restarting automaticaly at frequent intervals. 
> Restarting 
> > is not
> > effective until I ran isamchk and found that the RADONLINE 
> was corrupt 
> > and
> > fix it with -o option.
> >
> > We are very much concern about this since it was repeated 
> during the 
> > last
> > couple of days (during peak time) and try to find a 
> workaround for this
> > problem. Current max_connection setting on MySQL server  is 
> > 100(default) and
> > wonder whether this is due to high load.
> >
> > Looking forward to your earliest response.
> >
> > Best Regards,
> > Deen
> >
> > -------------------------------------------------------
> >
> > --
> > Mike McCauley                               mikem at open.com.au
> > Open System Consultants Pty. Ltd            Unix, Perl, 
> Motif, C++, WWW
> > 24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
> > Phone +61 3 9598-0985                       Fax   +61 3 9598-0955
> >
> > Radiator: the most portable, flexible and configurable RADIUS server
> > anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> > Platypus, Freeside, TACACS+, PAM, external, Active 
> Directory, EAP, TLS,
> > TTLS etc on Unix, Windows, MacOS etc.
> >
> > ===
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' with
> > 'unsubscribe radiator' in the body of the message.
> >
> >
> 
> --
> 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.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
> 
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.