(RADIATOR) MySQL tuning and performance

[Lanny Jason Godsey]

Has SQLRecoveryFile been fixed to work with MySQL?  If not, MySQL
accounting is not reliable.

6.29.21 SQLRecoveryFile

This optional parameter specifies the name of a file where any failed
SQL do queries will be logged, perhaps for later recovery. The default
is no logging. The SQLRecoveryFile file is always opened written and
closed for each failed SQL do query, so you can safely rotate it at any
time.

Hint : You may want to make the filename depend on the date, so you get
one missed accounting file per day.
 
# Log all failed SQL queries to a log file per day
SQLRecoveryFile %L/sqlfailures


--- Hugh Irvine <hugh at open.com.au> wrote:

> 
> Hello Everyone -
> 
> As many Radiator users employ MySQL for their backend SQL database,  
> we would be very interested in hearing what sort of performance  
> numbers you are getting (on what sort of hardware and operating  
> system), and what tuning methods you have used to achieve that  
> performance.
> 
> We would like to put together a MySQL tuing hints document for the  
> "goodies".
> 
> Of course, any similar information on other popular databases will  
> also be included.
> 
> many thanks
> 
> regards
> 
> Hugh
> 
> 
> NB:
> 
> Have you read the reference manual ("doc/ref.html")?
> Have you searched the mailing list archive (www.open.com.au/archives/
> 
> radiator)?
> Have you had a quick look on Google (www.google.com)?
> Have you included a copy of your configuration file (no secrets),
> together with a trace 4 debug showing what is happening?
> 
> -- 
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
> -
> Nets: internetwork inventory and management - graphical, extensible,
> flexible with hardware, software, platform and database independence.
> -
> CATool: Private Certificate Authority for Unix and Unix-like systems.
> 
> 
> --
> 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.