This script is to monitor SQL transactions over the wire.<\/p>\n
This script is to monitor SQL transactions over the wire. #!\/bin\/bash #this script used\u00a0monitor\u00a0mysql network traffic.echo sql tcpdump -i eno1 -s 0 -l -w – dst port 3306 | strings | perl -e ‘ while() { chomp; next if \/^[^ ]+[ ]*$\/; if(\/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER|CALL)\/i) { if (defined $q) { print “$q\\n”; } $q=$_; } else { […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.hegars.com\/index.php?rest_route=\/wp\/v2\/posts\/6"}],"collection":[{"href":"https:\/\/blog.hegars.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hegars.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hegars.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hegars.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6"}],"version-history":[{"count":2,"href":"https:\/\/blog.hegars.com\/index.php?rest_route=\/wp\/v2\/posts\/6\/revisions"}],"predecessor-version":[{"id":194,"href":"https:\/\/blog.hegars.com\/index.php?rest_route=\/wp\/v2\/posts\/6\/revisions\/194"}],"wp:attachment":[{"href":"https:\/\/blog.hegars.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hegars.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hegars.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}#!\/bin\/bash
\n#this script used\u00a0monitor\u00a0mysql network traffic.echo sql
\ntcpdump -i eno1 -s 0 -l -w - dst port 3306 | strings | perl -e '
\nwhile() { chomp; next if \/^[^ ]+[ ]*$\/;
\nif(\/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER|CALL)\/i)
\n{
\nif (defined $q) { print \"$q\\n\"; }
\n$q=$_;
\n} else {
\n$_ =~ s\/^[ \\t]+\/\/; $q.=\" $_\";
\n}
\n}'<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"