Re: FreeRadius crashed on accounting load tests with 1000 concurrent?clients

2009-11-11 Thread Alexander Clouter
Alan DeKok wrote: > >> If I can not find something wrong caused by us, I will fill a bug >> report. So far, nothing is found. > > All of the time you spend investigating things is WASTED. The ONLY > thing that will help is to follow the instructions in doc/bugs. > > Follow the instructions i

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Alan DeKok
Dinh Pham Cong wrote: > Thanks Alan. I am reviewing my system to see if there is any wrong in > our system settings that can cause FreeRadius crashed under high load. Think about that for a second. Is there really a configuration setting that says "crash under high load" ? I don't think so.

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Michael da Silva Pereira
Ok, well there would be no point going sub second, as long as its a reasonable amount. Have you tried using a perl or python module to handle the auth / acct? Thanks, Michael On Wed, 2009-11-11 at 00:36 +0700, Dinh Pham Cong wrote: > Hi Michael, > > Yes I have enabled MySQL slow query log for a

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Dinh Pham Cong
Hi Michael, Yes I have enabled MySQL slow query log for all queries that take more than 1s for execution. I have found 2 slow queries only (INSERT) in one server and no slow query on the other. Because I installed MySQL using a rpm package so I can not patch it with microslow patch to enable loggi

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Michael da Silva Pereira
Hi Dinh, I'm very interested to see your results, I have a freeradius + freebsd setup running and hit around 800 queries/per sec. As of yet rock solid :) (64Bit as well). Following the thread you also sent the "Discarding duplicate request from client tester1 port" error. I'm interested to see th

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Dinh Pham Cong
Hi Alan, On Tue, Nov 10, 2009 at 11:25 PM, Alan DeKok wrote: > > But if you follow the instructions in doc/bugs, you will be able to > give us the data we need to FIX the crash. > > Thanks Alan. I am reviewing my system to see if there is any wrong in our system settings that can cause FreeRadius

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Alan DeKok
Dinh Pham Cong wrote: > I have enabled sqltrace and found that for accounting purpose, there was > only a single query made into MySQL for accounting stop or start: An > insert for start and a delete for stop. For single INSERT and/or DELETE > I have used mysqlslap for stress testing and found that

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Dinh Pham Cong
Hi Alan, I have attached a graph created by Munin that shows how MySQL works under FreeRadius load test http://img4.imageshack.us/img4/7204/mysqlqueriesday.png This test was conducted last night. I used 2 16-core Dell servers, FastEthernet 100Mb to run 2 test clients to test 2 Radius servers. Ea

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Dinh Pham Cong
Hi Alan, On Tue, Nov 10, 2009 at 8:15 PM, Alan DeKok wrote: > > FreeRADIUS does a mix of selects, inserts and updates for accounting. > It may be that the DB can only handle 1000 transactions/s with that mix. > > See also "sqltrace" config in sql.conf. You can try the following tests: > > - s

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Alan DeKok
Alisson wrote: > I have the same problem with Freebsd + radius and Mysql 5. server hp > core 2 duo, 2 gb ram > > we have 1000 connections concurrent... and we have the same error > "discarding packet' > > Alan Dekok sayd to me that the problem is the same "slow database" > > I'm don't found a so

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Alan DeKok
Dinh Pham Cong wrote: > I saw that when 1000 client was created at the same time and send > requests to Radius server concurrently there were about 2000+ radiusd > threads were created too. I thought that 1000 concurrent client could be > translated to more than 1000 packets/s. Maybe. It depend

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Michael Schwartzkopff
Am Dienstag, 10. November 2009 13:02:50 schrieb Alisson: > I have the same problem with Freebsd + radius and Mysql 5. server hp core 2 > duo, 2 gb ram > > we have 1000 connections concurrent... and we have the same error > "discarding packet' > > Alan Dekok sayd to me that the problem is the same "

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Alisson
I have the same problem with Freebsd + radius and Mysql 5. server hp core 2 duo, 2 gb ram we have 1000 connections concurrent... and we have the same error "discarding packet' Alan Dekok sayd to me that the problem is the same "slow database" I'm don't found a solution yet 2009/11/10 Dinh Pha

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Dinh Pham Cong
Hi Alan, On Tue, Nov 10, 2009 at 5:35 PM, Alan DeKok wrote: > Dinh Pham Cong wrote: > > start_servers = 1024 > > max_servers = 3000 > > max_spare_servers = 3000 > > That's a little high. > > I saw that when 1000 client was created at the same time and send requests to Radius server concurrently

Re: FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Alan DeKok
Dinh Pham Cong wrote: > start_servers = 1024 > max_servers = 3000 > max_spare_servers = 3000 That's a little high. > My sql.conf > > # number of sql connections to make to server > num_sql_socks = 1000 Remember: 1000 packets/s does *not* mean 1000 threads or 1000 SQL sockets. The server sh

FreeRadius crashed on accounting load tests with 1000 concurrent clients

2009-11-10 Thread Dinh Pham Cong
Hi all, I am using FreeRADIUS Version 2.1.7, CentOS 5.3 64 bit, MySQL 5.0.77 (max connections 3000) on a 16-core, 16GB RAM server. This is my radiusd.conf max_request_time = 10 cleanup_delay = 5 max_requests = 5120 start_servers = 1024 max_servers = 3000 max_spare_servers = 3000 max_requests_per