RE: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-29 Thread Marie Tambe
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]

Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-29 Thread Alan DeKok
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

Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-29 Thread Johan Meiring
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

RE: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-29 Thread Marie Tambe
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

Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-29 Thread Alan Buxey
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

Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-28 Thread Marie Tambe
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

Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-28 Thread Alan DeKok
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

RE: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-28 Thread Marie Tambe
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

Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-28 Thread Alan DeKok
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

Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-28 Thread Alan Buxey
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

RE: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

2010-09-28 Thread Marie Tambe
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