Fajar,
> So you mean radutmp was the root cause of your problem?
I don't know, but it's better now. =)
> What does FR log says? Does it say it recives duplicate or conflicting
packets?
> If yes, then the db is still slow. You still need to fix it. If not,
> then the problem might be somewhere el
Hi Arran,
> It doesn't support row level locking for one. Which absolutely cripples
selects against the radacct/postauth table when there are
> high levels of inserts/updates.
>
> MyISAM should *NOT* be used for the postauth and radacct. Version 3 schema
has been updated to use INNODB for these ta
Daniel Menezes wrote:
> I don't know better than anyone, I'm simply asking to understand where I'm
> lost.
Then you should ask "WHY is one better than the other".
> Sorry if you feel bad with my questions ..
Which is proof you didn't understand my response.
Alan DeKok.
-
List info/subscri
Hi Alan,
> If you know better than the RADIUS experts, why are you asking
> questions on this list?
I don't know better than anyone, I'm simply asking to understand where I'm
lost.
Sorry if you feel bad with my questions ..
Sds,
---
Daniel Menezes
-
List info/subscribe/unsubscribe? See ht
On 27 Oct 2011, at 16:16, Alan DeKok wrote:
> Daniel Menezes wrote:
>>> 1. User the InnoDB Engine in MySQL.
>> I read about it and don't know if it's the best way.
>> Why InnoDB engine? MySAM engine is more fast.
>
It doesn't support row level locking for one. Which absolutely cripples selects
Daniel Menezes wrote:
>> 1. User the InnoDB Engine in MySQL.
> I read about it and don't know if it's the best way.
> Why InnoDB engine? MySAM engine is more fast.
If you know better than the RADIUS experts, why are you asking
questions on this list?
Alan DeKok.
-
List info/subscribe/unsubscr
Hi Tim,
> 1. User the InnoDB Engine in MySQL.
I read about it and don't know if it's the best way.
Why InnoDB engine? MySAM engine is more fast.
> 2. Increase the number of SQL sockets in sql.conf (num_sql_socks). The
> default is 5, try 25.
Ok.
> 3. Increase the number of connections (max_conn
Fajar,
I had radutmp and SQL commented out in account {}.
I don't know why, a possible mistake.
After mark radutmp and restart freeradius I don't see new errors in log.
In the NAS (MikroTik) statistics sometimes have a few resends and timeouts,
it's normal?
Sds,
---
Daniel Menezes
-Men
Yes, there is a large number of rows in the radacct and radposauth tables.
The attribute 'Acct-Interim-Interval' works very well but makes many
records.
I rotate these tables to archive old records, I think I'll do this every
month.
Of course, the script wouldn't solve all my problems, but it was
9 matches
Mail list logo
