<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
p.arial, li.arial, div.arial
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I would like to minimize the amount of data getting sent up
from some of my log files by filtering out everything I’m not interested
in – which is basically everything except a few records.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I tried the following:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> log:/cvsrx/cvsDB/mysqld.err:2048<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> trigger .*(InnoDB: Error|InnoDB:
Starting crash recovery|InnoDB: Database was not shut down normally).*<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> ignore .*<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>and<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>log:/cvsrx/cvsDB/mysqld.err:0<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> trigger .*(InnoDB: Error|InnoDB:
Starting crash recovery|InnoDB: Database was not shut down normally).*<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Neither of the above was completely successful – I am
still getting ‘extra’ data or not getting the lines matching the
trigger .<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any suggestions?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p><b><i><font size=1 color=gray face=Arial><span style='font-size:7.5pt;
font-family:Arial;color:gray;font-weight:bold;font-style:italic'>Thomas Brand </span></font></i></b><b><i><font
size=1 color=red face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:red;font-weight:bold;font-style:italic'>| CVS Caremark |</span></font></i></b><b><i><font
size=1 color=gray face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:gray;font-weight:bold;font-style:italic'>Rx Systems Admin</span></font></i></b><b><i><font
size=1 color=red face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:red;font-weight:bold;font-style:italic'>|Office: </span></font></i></b><b><i><font
size=1 color=gray face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:gray;font-weight:bold;font-style:italic'>401-770-4932</span></font></i></b><b><i><font
size=1 color=red face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:red;font-weight:bold;font-style:italic'> |</span></font></i></b><b><i><font
size=1 color=gray face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:gray;font-weight:bold;font-style:italic'><u2:address w:st="on"><u2:Street w:st="on">1
<u2:address w:st="on"><u2:Street w:st="on"><u3:address w:st="on"><u3:Street w:st="on"><st1:Street
w:st="on">CVS Drive</u2:Street></u2:address></u3:Street></u2:address></u2:Street></u2:address></st1:Street>,
<u2:City w:st="on"><st1:City w:st="on">Woonsocket</u2:City></st1:City>, <u2:State w:st="on"><st1:State
w:st="on">RI</u2:State></st1:State> <u2:PostalCode w:st="on"><st1:PostalCode
w:st="on">02895</u2:PostalCode></u2:PostalCode></st1:PostalCode> Mail Stop
34040C</span></font></i></b><b><i><font size=1 color=red face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:red;font-weight:bold;font-style:
italic'> </span></font></i></b><b><i><font size=1 color=gray face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:gray;font-weight:bold;
font-style:italic'> </span></font></i></b><b><i><font size=1 color=red
face=Arial><span style='font-size:7.5pt;font-family:Arial;color:red;font-weight:
bold;font-style:italic'>| </span></font></i></b><a href="mailto:TRBrand@cvs.com"><b><i><font
size=1 face=Arial><span style='font-size:7.5pt;font-family:Arial;font-weight:
bold;font-style:italic'>TRBrand@cvs.com</span></font></i></b></a><b><i><font
size=1 color=blue face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:blue;font-weight:bold;font-style:italic'><o:p></o:p></span></font></i></b></p>
<p class=MsoNormal><i><font size=1 color="#999999" face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:#999999;font-style:italic'>Disclaimer:
1) all opinions are my own, 2) I may be completely wrong, 3) my advice is worth
at least as much as what you are paying for it, or your money cheerfully
refunded.<o:p></o:p></span></font></i></p>
<p class=arial><font size=1 color="#999999" face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:#999999'>CONFIDENTIALITY NOTICE: This
communication and any attachments may contain confidential and/or privileged
information for</span></font><font size=1 color=gray face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:gray'> the use of the designated
recipients named above. If you are not the intended recipient, you are
hereby notified that you have received this communication in error and that any
review, disclosure, dissemination, distribution or copying of it or its
contents is prohibited. If you have received this communication in error,
please notify the sender immediately by telephone and destroy all copies of
this communication and any attachments.</span></font><font size=1 color=gray
face=Arial><span style='font-size:7.5pt;font-family:Arial;color:gray'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>