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:[EMAIL PROTECTED]] > Sent: Wednesday, September 04, 2002 12:48 AM > To: [EMAIL PROTECTED]; Shirantha Peiris > Cc: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > > > 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 [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] > > To unsubscribe, email '[EMAIL PROTECTED]' 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 [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. > === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
