If anybody is using mysql for Radius.
Could you tell me columns that you have created index for?
Thanks and Regards
Marie
-Original Message-
From: freeradius-users-bounces+mtambe=usatech@lists.freeradius.org
[mailto:freeradius-users-bounces+mtambe=usatech@lists.freeradius.org]
Marie Tambe wrote:
If anybody is using mysql for Radius.
Could you tell me columns that you have created index for?
The default schema creates the right indexes.
I've seen people have issues with MySQL when they're *not* using the
default schema, or when they have more data than the
On 2010/09/29 06:58 PM, Marie Tambe wrote:
If anybody is using mysql for Radius.
Could you tell me columns that you have created index for?
Your question is invalid.
Go buy a sql book.
PS: It's already been suggested that this is the Freeradius list, not the
mysql list.
PPS: Buy a book
Mysql is the backend database of radius and therefore any help in this regard
is appreciated as this is affecting the stability of the radius Apps
Thanks and Regards
Marie
-Original Message-
From: freeradius-users-bounces+mtambe=usatech@lists.freeradius.org
Hi,
Mysql is the backend database of radius and therefore any help in this regard
is appreciated as this is affecting the stability of the radius Apps
MySQL is a database system. This is a FreeRADIUS mailing list for the
dissemination of hints, methods, tips and configs for the FreeRADIUS
Can someone help with this Please.
I always have restart server before radius can record again
on Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active,
cannot spawn new thread to handle request
Mon Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are
Marie Tambe wrote:
Can someone help with this Please.
I always have restart server before radius can record again
It's not a RADIUS problem.
on Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are
active, cannot spawn new thread to handle request
...
Mon Sep 20 18:45:19
I am not a mysql expert but need to support it.
How can I fix the database?
Is it related to the server resources as well?
Thanks and Regards
Marie
-Original Message-
From: freeradius-users-bounces+mtambe=usatech@lists.freeradius.org
Marie Tambe wrote:
I am not a mysql expert but need to support it.
How can I fix the database?
Ask the MySQL people how to make the database responsive.
In short, you've put too many rows in the DB without indexes.
Is it related to the server resources as well?
See my previous
Hi,
I am not a mysql expert but need to support it.
How can I fix the database?
Is it related to the server resources as well?
server resources as in memory and CPU and disk speed? most likely.
this is a FreeRADIUS mailing list - which DB are you using - I'd suggest
going to the relevent
We are using mysql database for Radius
Thanks and Regards
Marie
-Original Message-
From: freeradius-users-bounces+mtambe=usatech@lists.freeradius.org
[mailto:freeradius-users-bounces+mtambe=usatech@lists.freeradius.org] On
Behalf Of Alan Buxey
Sent: Tuesday, September 28, 2010
11 matches
Mail list logo