Re: Major impact on authentication!

--===============1475664214==
Content-Type: multipart/alternative;
boundary="----=_Part_22626_24915865.1170700585968"

------=_Part_22626_24915865.1170700585968
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I'm testing PostgreSQL performance with various tools.

Thanks!


On 2/5/07, Dennis Skinner <dskinner@bluefrog.com> wrote:
>
> Alan DeKok wrote:
> >> As this is random, it's hard to debug, but at the same time freeradius
> >> loses the connection, several other applications can successfully
> >> connect/ maintain previous established connections to the databases.
> >
> > FreeRADIUS is NOT losing its connection to the DB. If you think
> > that's happening, you will try to fix a problem that doesn't exist, and
> > will NOT solve the real problem.
> >
> >> I've enabled all sorts of debug in the databases trying to better
> >> understand why freeradius is doing this, but there was no luck.
> >
> > Find out why the database isn't responding to FreeRADIUS.
>
> I had similar issues at one time with MySQL and FreeRADIUS. There is an
> app out there for MySQL called Mytop which is basically like the unix
> "top" command, but looks at MySQL processes. This makes it very easy to
> watch and see what processes are taking too long and holding up the rest.
>
> I'm not sure if there is a similar app out there for postgresql, but
> it'd be worth a look.
>
> --
> Dennis Skinner
> Systems Administrator
> BlueFrog Internet
> http://www.bluefrog.com
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>

------=_Part_22626_24915865.1170700585968
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>I'm testing PostgreSQL performance with various tools.</div>
<div>&nbsp;</div>
<div>Thanks!<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 2/5/07, <b class="gmail_sendername">Dennis Skinner</b> &lt;<a href="mailto:dskinner@bluefrog.com">dskinner@bluef rog.com</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Alan DeKok wrote:<br>&gt;&gt; As this is random, it's hard to debug, but at the same time freeradius<br>
&gt;&gt; loses the connection, several other applications can successfully<br>&gt;&gt; connect/ maintain previous established connections to the databases.<br>&gt;<br>&gt;&nbsp;&nbsp; FreeRADIUS is NOT losing its connection to the DB.&nbsp;&nbsp;If you think
<br>&gt; that's happening, you will try to fix a problem that doesn't exist, and<br>&gt; will NOT solve the real problem.<br>&gt;<br>&gt;&gt; I've enabled all sorts of debug in the databases trying to better<br>
&gt;&gt; understand why freeradius is doing this, but there was no luck.<br>&gt;<br>&gt;&nbsp;&nbsp; Find out why the database isn't responding to FreeRADIUS.<br><br>I had similar issues at one time with MySQL and FreeRADIUS.&nbsp;&nbsp;There is an
<br>app out there for MySQL called Mytop which is basically like the unix<br>&quot;top&quot; command, but looks at MySQL processes.&nbsp;&nbsp;This makes it very easy to<br>watch and see what processes are taking too long and holding up the rest.
<br><br>I'm not sure if there is a similar app out there for postgresql, but<br>it'd be worth a look.<br><br>--<br>Dennis Skinner<br>Systems Administrator<br>BlueFrog Internet<br><a href="http://www.bluefrog.com">
http://www.bluefrog.com</a><br>-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a><br></blockquote></div><br>

------=_Part_22626_24915865.1170700585968--

--===============1475664214==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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