> Good day all
> We are trying to find out where the current connections
> on
> our Mysql database originates from.
>
> We are receiving 4000+ connections at the moment where
> this
> was usually only about half this.
>
> Is there a way of determining where the connections
> originates from ? i.e - website, internal, import scripts, etc...
>
show processlist;
but I dont think you can determine if it is from webserver etc - dont
think it matters to mysql really.
it will provide user/host/query/ID ...
Also I am sure you can find some third party tools doing the same.
--
bEsT rEgArDs | "Confidence is what you have before you
tomasz dereszynski | understand the problem." -- Woody Allen
|
Spes confisa Deo | "In theory, theory and practice are much
numquam confusa recedit | the same. In practice they are very
| different." -- Albert Einstein
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
