Thx Alan
I coded a very simple script to check the mysl server latency:
#!/bin/sh
ExecQuery ()
{
echo "select count(*) from radacct;" | mysql -h mysqlserver -u
radiususer --password=radiuspassword radaccoutingdb
}
while [ -n 1 ]
do
echo -n "starting query."
date
magicboiz wrote:
> Do you know how can I modify the source code, in order to print in the error
> message the exact time when the child was created/forked? If I want to find
> errors in my sql backend server, I need to know the exact time when the
> requests are lost.. checking the code, It
First, optimize your database, add indexes and use storage engines which
will give you the best performance... Increase interim-update interval
After that, try to add more handlers and see what will happen.
If you're using mysql, check tuning-primer.sh and mysqltuner.pl scripts.
On Thu, Feb 26,
HI again Ivan
Do you know how can I modify the source code, in order to print in the error
message the exact time when the child was created/forked? If I want to find
errors in my sql backend server, I need to know the exact time when the
requests are lost.. checking the code, It looks like
Thx Ivan,
and do you know if the accouting registers is lost? or another child retries
the insert into the database?
thx
Regards
On MiƩrcoles 25 Febrero 2009 14:09:44 t...@kalik.net wrote:
> >I facing this problem with my Freeradius 2.1.3, and I don't know how to
> > solve it :(
> >
> >My NAS
>I facing this problem with my Freeradius 2.1.3, and I don't know how to solve
>it :(
>
>My NAS is sending only accounting registers to my freeradius server. My
>freeradius server, is configured to store these registers into a MySQL server.
>I have configured "max_request_time = 120", in the case o
6 matches
Mail list logo