From: David Lerer Date: October 10 2012 1:24pm Subject: Re: Monitoring Sessions List-Archive: http://lists.mysql.com/mysql/228361 Message-Id: <54CA41808CE65943855971AE22F52C052F42B498@EWR-EXMBX03.utg.uvn.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable We have tried Oracle tool (MySQL Enterprise Monitor) which allows you to ca= pture and analyze queries submitted from selected hosts, for a specific tim= e window. The tool and its user interface were very useful in identifying t= he volume and heavy queries. Licensing and (cost) may be an issue. I have = not tried the Percona tool. David.=20 ----- Original Message ----- From: Anupam Karmarkar [mailto:sb_akarmarkar@stripped] Sent: Wednesday, October 10, 2012 08:02 AM=0A= To: mysql@stripped Subject: Re: Monitoring Sessions Thanks Johan for info,=0A= =0A= We already tried with tcpdump and wireshark it was helpfull. Percona tool k= it i need to try.=0A= =0A= =0A= =0A= ________________________________=0A= From: Johan De Meersman =0A= To: Anupam Karmarkar =0A= Cc: mysql@stripped =0A= Sent: Wednesday, 10 October 2012 5:16 PM=0A= Subject: Re: Monitoring Sessions=0A= =0A= ----- Original Message -----=0A= > From: "Anupam Karmarkar" =0A= > =0A= > How to monitor individual session number of rows selected or updated=0A= > by sessions, number of bytes sent and reviewed by session in a given=0A= > time period, sessions connects runs command and then disconnects,=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= > requesting 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 network level but can we get more=0A= > details as mention.=0A= =0A= Well, you can look at the local (session) status, but that would require ea= ch session to actually 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= =0A= The general log file will also save you entire sessions, but will do so for= EVERY session that happens - which is going to make for a huge overhead on= the busy machine you seem to be describing, so is definitely not recommend= ed.=0A= =0A= Someone also recently posted links towards an init-sql based approach which= might be adapted, and towards a McAfee Auditing module for MyQSL that also= seemed to hold some promise.=0A= =0A= =0A= -- =0A= Linux Bier Wanderung 2012, now also available in Belgium!=0A= August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be=0A= =0A= -- =0A= MySQL General Mailing List=0A= For list archives: http://lists.mysql.com/mysql=0A= To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql= The information contained in this e-mail and any attached documents may be privileged, confidential and protected from disclosure. If you are not the intended recipient you may not read, copy, distribute or use this information. If you have received this communication in error, please notify the sender immediately by replying to this message and then delete it from your system.