Re: How do I stop reading of detail file after a certain threshold is reached

2012-03-08 Thread Vivek Mehrotra
Thanks Alan and Fajar, How do I ensure the buffered-sql file gets included by the server? Do I need an additional default Virtual Server configuration to enable the buffered-sql? Where are the SQL queries picked up from if there is no buffered sql? Also, how does dialup admin interface pick up

Re: How do I stop reading of detail file after a certain threshold is reached

2012-03-08 Thread Alan Buxey
Hi, How do I ensure the buffered-sql file gets included by the server? Do I need an additional default Virtual Server configuration to enable the buffered-sql? you ensure theres a link to it from sites-enabled into sites-available Where are the SQL queries picked up from if there is no

Re: How do I stop reading of detail file after a certain threshold is reached

2012-03-05 Thread Alan Buxey
Hi, We are using Freeradius2 with MySQL at the backend. I understand that the buffered sql takes care of buffering queries. What is the best way to stop querying MySQL altogether and return a negative response, after a certain threshold of processing is reached by the server? buffered_sql

How do I stop reading of detail file after a certain threshold is reached

2012-03-04 Thread Vivek Mehrotra
Hello, We are using Freeradius2 with MySQL at the backend. I understand that the buffered sql takes care of buffering queries. What is the best way to stop querying MySQL altogether and return a negative response, after a certain threshold of processing is reached by the server? Thanks in

Re: How do I stop reading of detail file after a certain threshold is reached

2012-03-04 Thread Fajar A. Nugraha
On Mon, Mar 5, 2012 at 12:01 PM, Vivek Mehrotra vme...@yahoo.com wrote: Hello, We are using Freeradius2 with MySQL at the backend. I understand that the buffered sql takes care of buffering queries. What is the best way to stop querying MySQL altogether and return a negative response, after

Re: How do I stop reading of detail file after a certain threshold is reached

2012-03-04 Thread Vivek Mehrotra
As the number of queries increases to a few ten-thousands, mysqld monopolizes the CPU. We wish to stop querying MySQL at that point. There's only so much load_factor can help? Would welcome alternate solutions as well.. Regards, vivek - List info/subscribe/unsubscribe? See

Re: How do I stop reading of detail file after a certain threshold is reached

2012-03-04 Thread Fajar A. Nugraha
On Mon, Mar 5, 2012 at 12:48 PM, Vivek Mehrotra vme...@yahoo.com wrote: As the number of queries increases to a few ten-thousands, mysqld monopolizes the CPU. We wish to stop querying MySQL at that point. There's only so much load_factor can help? Would welcome alternate solutions as well..