Workload in freeradius? platform

[siguillaume]

Ok, Thanks.
We have started a new test today.
In file attached, i give the results of radiusd -X | tee log, on the both authentication servers.

We see some errors but don't understand as well.
Date: Fri, 14 Oct 2011 16:36:19 -0700
From: ml-node+s1045715n4904200h94 at n5.nabble.com
To: gsigui at live.fr
Subject: Re: Workload in freeradius? platform



	On Fri, Oct 14, 2011 at 10:47 PM, Guillaume Sigui <[hidden email]> wrote:

> Ok, sorry. I explain below with more details:


Guillaume, let me put this another way.


Most of the things you've wrote is irrelevant to this list.

This list is freeradius mailing list. Not alcatel list, not mysql

list, not some support for an ISP.


You asked a question "why is freeradius slow". Then you were given a

response "which part of it is slow". Then you posted a lot of

information, but none of which is really relevant. Then you posted log

of radiusd -X starting up, but without it receiving any packets at

all, thus making it almost useless for diagnostic purposes.


Do you understand now why some people here have expressed frustration

reading your post, even to go as far as unsubscribing you?


I'm going to assume that you don't deliberately intend to do so, and

that you simply don't know where to look. Here's a hint: when

freeradius is slow, usually it's the backend that's slow. The backend

can be:

- a database (e.g. Mysql)

- ldap

- another radius server (when running proxy configuration)


How can you find out what's slow? One way (but not the only way) would be:

- run freeradius in debugging mode

- send access-request and/or accounting packets for ONE session

- see where it's slow


Usually that means you need to have a test server, with freeradius

installed, using the same backend that your production server uses.

After you find out what's causing the slowness, then

freeradius-related part is complete. You'll need to work on whatever

it is on the backend that's causing the slowness.



Now, since you say


> - each server has his own database server, so there are 04 database servers.

> It's Mysql 5.


Then most likely the problem is in the database. Usual causes:

- there are too many accounting records (e.g. several millions), and

your configuration scans the records every time an authentication

occurs (e.g. for simultaneous-check)

- the table structurs has non-optimal index, or your queries are

non-optimal that it uses many full table scans

- your db server performance simply sucks



Are you still with me so far?



Now if my previous guess is correct, then to further diagnose this

problem you need a DBA. If you don't have the skills needed, hire one.

A DBA would be able to determine whether or not MySQL is REALLY the

cause of slowness, and he'll also be able to do some steps to improve

the performance.


If you DON'T have a DBA, and DON'T intend to hire one, then I can only

say sorry, but no ammount of mail posted to any mailing list will be

able to help you. You'll just annoy others.


-- 

Fajar

-

List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

	
	

	

	
	
		If you reply to this email, your message will be added to the discussion below:
		http://freeradius.1045715.n5.nabble.com/Workload-in-freeradius-platform-tp4898456p4904200.html
	
	
		
		To unsubscribe from Workload in freeradius‏ platform, click here.
	 		 	   		  

--
View this message in context: http://freeradius.1045715.n5.nabble.com/Workload-in-freeradius-platform-tp4898456p4931877.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20111024/b28d3140/attachment.html>