Determine connection origins

2010-06-30 Thread Machiel Richards
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...

 

Machiel Richards

MySQL DBA

Relational Database Consulting 

 

RDC_Logo

 



Re: Determine connection origins

2010-06-30 Thread tomasz dereszynski

 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/mysql?unsub=arch...@jab.org