Lasso to Filemaker 12 Server Connected Clients

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Lasso to Filemaker 12 Server Connected Clients

Keith M. Rettig
When I access my Filemaker Server v12 using the Filemaker Server Admin Console and go to the Clients tab I can see the list of users connected to the server.
        There is me as the one user connected to the database with my Filemaker Advanced v12.  Great.
        Then there are the 80 lasso users.  All of them connected from the Apache Server that is running Lasso.  Not so great.
                I am assuming that there are no more than 80 because I have Filemaker Server configured to a maximum number of 80 Custom Web Publishing sessions.

If I select all 80 users and perform the “Disconnect” option, they all just come back within a minute or so.

I am hosting just a few sites.  I can view all the logs on the server and there aren’t enough hits to the web server to explain the number of these lasso user connections and how fast they are connecting [after I disconnect them all].
It seems as if the connections that I see in the logs (all hits that would be expected) are just not letting go. . . or something is looping; but I can not figure out what it might be.
This of course seems to be the explain as to why when I connect to the web server via the web browser my connection seems slow; I assume my request has to wait for one of these lasso users to drop.


Can anyone direct me to where I should look or what I should do to figure out where/what/why these connections are all there?
Logging into the Lasso Admin page doesn’t really give me any direction other than I can see the number of threads it claims are there.  Unfortunately the number indicated by Lasso Admin is far less than the number indicated by the Filemaker Admin console.


I am perplexed (have been for awhile as I try to solve this) and frustrated.
Thanks for any leads.
Keith.
#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso to Filemaker 12 Server Connected Clients

stevepiercy
This is not unusual behavior for websites that have a large
number of requests.

It is not a good idea to disconnect connections by the lasso
user because the http request is still active on the web server
and will simply reconnect immediately.  You observed this
behavior in action.

The issue may be the duration that each request is taking to
complete.  Connections will not release until the process is
completed.  If you have intensive FileMaker queries that take a
long time to complete, requests will back up to the limit of the
connections set in FMS (off the top of my head, I think the
maximum setting is 250).

So you need to identify the long processes.  This can be used as
a starting point.
http://lasso.2283332.n4.nabble.com/Re-CPU-stuck-high-td3153325.html

The logging can be done to a text file or to a MySQL database.  
You can also modify the script to delete records that complete,
leaving you with only records that indicate which requests never completed.

--steve


On 7/17/14 at 5:05 AM, [hidden email] (Keith M. Rettig) pronounced:

>When I access my Filemaker Server v12 using the Filemaker
>Server Admin Console and go to the Clients tab I can see the
>list of users connected to the server.
>There is me as the one user connected to the database with my
>Filemaker Advanced v12.  Great.
>Then there are the 80 lasso users.  All of them connected from
>the Apache Server that is running Lasso.  Not so great.
>I am assuming that there are no more than 80 because I have
>Filemaker Server configured to a maximum number of 80 Custom
>Web Publishing sessions.
>
>If I select all 80 users and perform the “Disconnect”
>option, they all just come back within a minute or so.
>
>I am hosting just a few sites.  I can view all the logs on the
>server and there aren’t enough hits to the web server to
>explain the number of these lasso user connections and how fast
>they are connecting [after I disconnect them all].
>It seems as if the connections that I see in the logs (all hits
>that would be expected) are just not letting go. . . or
>something is looping; but I can not figure out what it might be.
>This of course seems to be the explain as to why when I connect
>to the web server via the web browser my connection seems slow;
>I assume my request has to wait for one of these lasso users to drop.
>
>
>Can anyone direct me to where I should look or what I should do
>to figure out where/what/why these connections are all there?
>Logging into the Lasso Admin page doesn’t really give me any
>direction other than I can see the number of threads it claims
>are there.  Unfortunately the number indicated by Lasso Admin
>is far less than the number indicated by the Filemaker Admin console.
>
>
>I am perplexed (have been for awhile as I try to solve this) and frustrated.
>Thanks for any leads.
>Keith.
>#############################################################
>Attend the Lasso Developer Conference 2014!
>October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>http://www.lassosoft.com/LDC-newmarket-2014
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy              Website Builder              Soquel, CA
<[hidden email]>               <http://www.StevePiercy.com/>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso to Filemaker 12 Server Connected Clients

maxwellk2
Hi Keith,

Steve recommendation are spot on.

I have a number of busy sites running an FMS12 server and when things are dialed in I see multiple fmxml type connections opening and then pretty quickly closing. When they stack up like that it’s a sign that Lasso is making a big and/or complex query of FileMaker, or the request has stalled.

When solving this issue in the past, the most common fix is to make sure Lasso is only searching indexed fields - searches on unstored calculations can be a big bottleneck. It can be a hassle to retool a solution to avoid un-stored calculations, but it has proven time and again to be what causes poor performance and connections to stack up.

HTH,
Max


On Jul 17, 2014, at 9:34 AM, Steve Piercy - Website Builder <[hidden email]> wrote:

> This is not unusual behavior for websites that have a large number of requests.
>
> It is not a good idea to disconnect connections by the lasso user because the http request is still active on the web server and will simply reconnect immediately.  You observed this behavior in action.
>
> The issue may be the duration that each request is taking to complete.  Connections will not release until the process is completed.  If you have intensive FileMaker queries that take a long time to complete, requests will back up to the limit of the connections set in FMS (off the top of my head, I think the maximum setting is 250).
>
> So you need to identify the long processes.  This can be used as a starting point.
> http://lasso.2283332.n4.nabble.com/Re-CPU-stuck-high-td3153325.html
>
> The logging can be done to a text file or to a MySQL database.  You can also modify the script to delete records that complete, leaving you with only records that indicate which requests never completed.
>
> --steve
>
>
> On 7/17/14 at 5:05 AM, [hidden email] (Keith M. Rettig) pronounced:
>
>> When I access my Filemaker Server v12 using the Filemaker Server Admin Console and go to the Clients tab I can see the list of users connected to the server.
>> There is me as the one user connected to the database with my Filemaker Advanced v12.  Great.
>> Then there are the 80 lasso users.  All of them connected from the Apache Server that is running Lasso.  Not so great.
>> I am assuming that there are no more than 80 because I have Filemaker Server configured to a maximum number of 80 Custom Web Publishing sessions.
>>
>> If I select all 80 users and perform the “Disconnect” option, they all just come back within a minute or so.
>>
>> I am hosting just a few sites.  I can view all the logs on the server and there aren’t enough hits to the web server to explain the number of these lasso user connections and how fast they are connecting [after I disconnect them all].
>> It seems as if the connections that I see in the logs (all hits that would be expected) are just not letting go. . . or something is looping; but I can not figure out what it might be.
>> This of course seems to be the explain as to why when I connect to the web server via the web browser my connection seems slow; I assume my request has to wait for one of these lasso users to drop.
>>
>>
>> Can anyone direct me to where I should look or what I should do to figure out where/what/why these connections are all there?
>> Logging into the Lasso Admin page doesn’t really give me any direction other than I can see the number of threads it claims are there.  Unfortunately the number indicated by Lasso Admin is far less than the number indicated by the Filemaker Admin console.
>>
>>
>> I am perplexed (have been for awhile as I try to solve this) and frustrated.
>> Thanks for any leads.
>> Keith.
>> #############################################################
>> Attend the Lasso Developer Conference 2014!
>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>> http://www.lassosoft.com/LDC-newmarket-2014
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy              Website Builder              Soquel, CA
> <[hidden email]>               <http://www.StevePiercy.com/>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> This message is sent to you because you are subscribed to
> the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso to Filemaker 12 Server Connected Clients

Eric Knibbe-2
There's a few other performance tips for FileMaker data sources here: <http://lassoguide.com/databases/filemaker-data-sources.html#performance-tips>
‐‐‐‐‐‐‐‐‐‐✂‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
Eric3
 

On 2014-07-19, at 7:57 PM, Maxwell Klein wrote:

> Hi Keith,
>
> Steve recommendation are spot on.
>
> I have a number of busy sites running an FMS12 server and when things are dialed in I see multiple fmxml type connections opening and then pretty quickly closing. When they stack up like that it’s a sign that Lasso is making a big and/or complex query of FileMaker, or the request has stalled.
>
> When solving this issue in the past, the most common fix is to make sure Lasso is only searching indexed fields - searches on unstored calculations can be a big bottleneck. It can be a hassle to retool a solution to avoid un-stored calculations, but it has proven time and again to be what causes poor performance and connections to stack up.
>
> HTH,
> Max
>
>
> On Jul 17, 2014, at 9:34 AM, Steve Piercy - Website Builder <[hidden email]> wrote:
>
>> This is not unusual behavior for websites that have a large number of requests.
>>
>> It is not a good idea to disconnect connections by the lasso user because the http request is still active on the web server and will simply reconnect immediately.  You observed this behavior in action.
>>
>> The issue may be the duration that each request is taking to complete.  Connections will not release until the process is completed.  If you have intensive FileMaker queries that take a long time to complete, requests will back up to the limit of the connections set in FMS (off the top of my head, I think the maximum setting is 250).
>>
>> So you need to identify the long processes.  This can be used as a starting point.
>> http://lasso.2283332.n4.nabble.com/Re-CPU-stuck-high-td3153325.html
>>
>> The logging can be done to a text file or to a MySQL database.  You can also modify the script to delete records that complete, leaving you with only records that indicate which requests never completed.
>>
>> --steve
>>
>>
>> On 7/17/14 at 5:05 AM, [hidden email] (Keith M. Rettig) pronounced:
>>
>>> When I access my Filemaker Server v12 using the Filemaker Server Admin Console and go to the Clients tab I can see the list of users connected to the server.
>>> There is me as the one user connected to the database with my Filemaker Advanced v12.  Great.
>>> Then there are the 80 lasso users.  All of them connected from the Apache Server that is running Lasso.  Not so great.
>>> I am assuming that there are no more than 80 because I have Filemaker Server configured to a maximum number of 80 Custom Web Publishing sessions.
>>>
>>> If I select all 80 users and perform the “Disconnect” option, they all just come back within a minute or so.
>>>
>>> I am hosting just a few sites.  I can view all the logs on the server and there aren’t enough hits to the web server to explain the number of these lasso user connections and how fast they are connecting [after I disconnect them all].
>>> It seems as if the connections that I see in the logs (all hits that would be expected) are just not letting go. . . or something is looping; but I can not figure out what it might be.
>>> This of course seems to be the explain as to why when I connect to the web server via the web browser my connection seems slow; I assume my request has to wait for one of these lasso users to drop.
>>>
>>>
>>> Can anyone direct me to where I should look or what I should do to figure out where/what/why these connections are all there?
>>> Logging into the Lasso Admin page doesn’t really give me any direction other than I can see the number of threads it claims are there.  Unfortunately the number indicated by Lasso Admin is far less than the number indicated by the Filemaker Admin console.
>>>
>>>
>>> I am perplexed (have been for awhile as I try to solve this) and frustrated.
>>> Thanks for any leads.
>>> Keith.
>>> #############################################################
>>> Attend the Lasso Developer Conference 2014!
>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>
>>> #############################################################
>>>
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso [hidden email]
>>> Official list archives available at http://www.lassotalk.com
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>> Steve Piercy              Website Builder              Soquel, CA
>> <[hidden email]>               <http://www.StevePiercy.com/>
>>
>> #############################################################
>> Attend the Lasso Developer Conference 2014!
>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>> http://www.lassosoft.com/LDC-newmarket-2014
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>