From: Anupam Karmarkar Date: October 10 2012 12:02pm Subject: Re: Monitoring Sessions List-Archive: http://lists.mysql.com/mysql/228360 Message-Id: <1349870531.21922.YahooMailNeo@web194606.mail.sg3.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1722158877-2086244608-1349870531=:21922" ---1722158877-2086244608-1349870531=:21922 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Thanks Johan for info,=0A=0AWe already tried with tcpdump and wireshark it = was helpfull. Percona tool kit i need to try.=0A=0A=0A=0A__________________= ______________=0A From: Johan De Meersman =0ATo: Anupam= Karmarkar =0ACc: mysql@stripped =0ASent: = Wednesday, 10 October 2012 5:16 PM=0ASubject: Re: Monitoring Sessions=0A = =0A----- Original Message -----=0A> From: "Anupam Karmarkar" =0A> =0A> How to monitor individual session number of rows selec= ted or updated=0A> by sessions, number of bytes sent and reviewed by sessio= n in a given=0A> time period, sessions connects runs command and then disco= nnects,=0A> SHOW GLOBAL STATUS is not helping me in this case as i want low= =0A> level session details, there are nearly 50's application server=0A> re= questing to 1 databases server, which server is generating more=0A> traffic= need to monitor and what kind of queries it is firing,=0A> binlog file are= genrating nearly 7-8 GB daily.=0A> =0A> Data trafic we can also get on net= work level but can we get more=0A> details as mention.=0A=0AWell, you can l= ook at the local (session) status, but that would require each session to a= ctually store those, as you can't access them outside of the session.=0A=0A= Alternatively, you can use tcpdump and wireshark to capture traffic as it g= oes through the wire and look at what's happening. Percona Toolkit's pt-que= ry-digest tool can also work with tcpdump logs.=0A=0AThe general log file w= ill also save you entire sessions, but will do so for EVERY session that ha= ppens - which is going to make for a huge overhead on the busy machine you = seem to be describing, so is definitely not recommended.=0A=0ASomeone also = recently posted links towards an init-sql based approach which might be ada= pted, and towards a McAfee Auditing module for MyQSL that also seemed to ho= ld some promise.=0A=0A=0A-- =0ALinux Bier Wanderung 2012, now also availabl= e in Belgium!=0AAugust, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxer= a.be=0A=0A-- =0AMySQL General Mailing List=0AFor list archives: http://list= s.mysql.com/mysql=0ATo unsubscribe:=A0 =A0 http://lists.mysql.com/mysql ---1722158877-2086244608-1349870531=:21922--