I intentionally didn't include the output of show full processlist
and show innodb status because they are very large to include them
here. If you need them, please tell me and I will send it to you
personally.
show full processlist would show how long some of the queries have been
running,
On Fri, Feb 12, 2010 at 6:22 AM, muffin sk muffi...@gmail.com wrote:
Slow queries: 166
Start with that. Activate slow query log (see Mysql docs) to see which
queries took a long time, and when they happen.
Combine that with freeradius log about db handle, and you should be
able to decide whether
Hello Fajar,
On Fri, Feb 12, 2010 at 8:48 AM, Fajar A. Nugraha fa...@fajar.net wrote:
On Fri, Feb 12, 2010 at 6:22 AM, muffin sk muffi...@gmail.com wrote:
Slow queries: 166
Start with that. Activate slow query log (see Mysql docs) to see which
queries took a long time, and when they happen.
muffin sk wrote:
- show full processlist
- show innodb status
Unfortunately your datbase is doing nothing in the logs attaced.
Please re-run and re-send show processlist while radius is claiming the
SQL pools to be unavailable, i.e. while your'e having the problem.
--
Johan Meiring
On Thu, Feb 11, 2010 at 10:23 AM, muffin sk muffi...@gmail.com wrote:
Can you briefly explain the
meaning for each line below if that doesn't cost much of your time? I
Which part are you having trouble with?
Thu Feb 11 05:53:24 2010 : Info: rlm_sql (sql): There are no DB
handles to use!
Hello Fajar,
First of all, thank you for your time answering my questions to this list.
On Thu, Feb 11, 2010 at 4:47 PM, Fajar A. Nugraha fa...@fajar.net wrote:
Thu Feb 11 05:53:24 2010 : Info: rlm_sql (sql): There are no DB
handles to use! skipped 0, tried to connect 0
usually this means
On Thu, Feb 11, 2010 at 11:08 PM, muffin sk muffi...@gmail.com wrote:
Thu Feb 11 05:53:24 2010 : Info: rlm_sql (sql): There are no DB
handles to use! skipped 0, tried to connect 0
usually this means the db is dead, or unresponsive, such that radiusd
can't find a DB handle it can use
What
Hello Fajar,
On Fri, Feb 12, 2010 at 12:42 AM, Fajar A. Nugraha fa...@fajar.net wrote:
When the NAS doesn't receive response (for whatever reason) in a
certain time, it should sends the request again. The number of retries
and timeout vary depending on NAS (tunable settings on some). If after
Hello all,
I need your help to understand the meaning of the following snippet of
the logs from the /var/log/radius/radius.log file of my FreeRADIUS
version 1.1.7-2 on top of CentOS 5.x. Can you briefly explain the
meaning for each line below if that doesn't cost much of your time? I
cannot find
9 matches
Mail list logo