[Info-ingres] Number of connected sessions

[Martin Bowes]

Hi All,

We have a system which can rapidly escalate its connection count via web based connections and is prone to exceeding the connection limit.

What I would like is a testable connection counter that is publicly accessible.

I don't want to give apache permission to access the server_sessions table in imadb. Furthermore, I suspect that having an ingres process regularly refresh a table with a count would simply impose a major bottleneck in the system.

I suspect the server keeps some internal counter of its connected sessions, would it be possible to expose that information in dbmsinfo()? That way I can install a soft connection limit and thus restrict to priority processes when the server gets loaded.

Marty

PS. My completely unreasonable boss made me ask this question.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20190123/724b32b0/attachment.html>