defaria.com/blogs/MAPS/archives/2007/07/hit-count-and-l.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5     <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6 <meta name="generator" content="Movable Type 5.2.3" />
   7 <link rel="stylesheet" href="http://defaria.com/blogs/MAPS/styles.css" type="text/css" />
   8 <link rel="start" href="http://defaria.com/blogs/MAPS/" title="Home" />
   9 <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/MAPS/atom.xml" />
  10 <script type="text/javascript" src="http://defaria.com/blogs/MAPS/mt.js"></script>
  11
  12
  13
  14     <link rel="prev bookmark" href="http://defaria.com/blogs/MAPS/archives/2006/04/no-more-defaria.html" title="No more &amp;lt;anything&amp;gt;@defaria.com" />
  15
  16
  17
  18     <title>Hit Count and Last Hit - MAPS</title>
  19 </head>
  20 <body id="classic-blog" class="mt-entry-archive layout-wtt">
  21     <div id="container">
  22         <div id="container-inner">
  23
  24
  25             <div id="header">
  26     <div id="header-inner">
  27         <div id="header-content">
  28
  29
  30             <div id="header-name"><a href="http://defaria.com/blogs/MAPS/" accesskey="1">MAPS</a></div>
  31             <div id="header-description"></div>
  32
  33         </div>
  34     </div>
  35 </div>
  36
  37
  38
  39             <div id="content">
  40                 <div id="content-inner">
  41
  42
  43                     <div id="alpha">
  44                         <div id="alpha-inner">
  45
  46
  47                             <div id="entry-651" class="entry-asset asset hentry">
  48                                 <div class="asset-header">
  49                                     <h1 id="page-title" class="asset-name entry-title">Hit Count and Last Hit</h1>
  50                                     <div class="asset-meta">
  51                                         <span class="byline">
  52
  53                                             <abbr class="published" title="2007-07-13T17:26:08-06:00">July 13, 2007  5:26 PM</abbr>
  54
  55                                         </span>
  56
  57
  58                                     </div>
  59                                 </div>
  60                                 <div class="asset-content entry-content">
  61
  62                                     <div class="asset-body">
  63                                         <p>After having left MAPS pretty much alone for a long time, though I did implement "nuke" which helps nuke whole domains, I finally have implemented new functionality for MAPS. You see over this last year or so I've been getting a lot of spam mostly oriented in which the domain name was wildly varying. So lots of mail loops were happening. Whacking whole domains became a favorite past time of mine and hence the "nuke" script (not an official part of MAPS mind you). Still it seemed like a losing battle.</p>
  64
  65 <p>Then I got to thinking - something I've been thinking for a while - how effective are all of my null list entries, now numbering in the 17K area! I thought that I could easily add some fields to the list table, namely a hit_count and a last_hit field, and then during scrubbing time see if these null list entries were at all effective, and if not then to automatically remove them.</p>
  66
  67 <p>So I added the fields and changed MAPS such that it records the hits and when the last hit happened. Then in mapsscrub check to see if last_hit is older than the number of days the user is keeping history. If it's 0 then simply remove that entry. Note this happens only for the null list. White list and black list are to be managed by the user. You purposely add somebody to the white or black list for a reason. Do we want to auto age these off? Probably not.</p>
  68
  69 <p>If the hit count is not 0 then how do we age off these apparently no longer effective null list entries? Well the though was to age them by subtracting 1 from the hit count. Thus if we had a null list entry that was fairly active for a little while and say accumulated a hit_count of 10 but then was largely un-hit, the hit_count would go 9, 8, 7, 6, 5... down to 0 and then the entry would be removed. I might want to change this as some null list entries are getting hit_counts in the thousands now! Assuming the user has a 30 day history then perhaps after 30 days of inactivity I should age any null list entry off the list in 7 days? Note that any activity in those 30 days would immediately reset the clock for at least the next 30 days (assuming a history of 30 days).</p>
  70
  71 <p>With this in place I decided to change the mail loop procedure to auto add the sender to the null list. Previously I was whacking off the whole domain - here we are just auto adding the individual sending address. But it's automatically added, automatically tracked for effectiveness and automatically aged off. Beside I still have the option of perusing the top returning domains and can whack whole domains still. Now any hits on any users in the domain will continue to insure that that domain null list entry will remain and not automatically age away...</p>
  72                                     </div>
  73
  74
  75                                 </div>
  76                                 <div class="asset-footer">
  77
  78
  79
  80
  81                                 </div>
  82                             </div>
  83
  84
  85
  86
  87
  88
  89                         </div>
  90                     </div>
  91
  92
  93                     <div id="beta">
  94     <div id="beta-inner">
  95
  96
  97
  98     <div class="widget-archive widget-archive-category widget">
  99     <h3 class="widget-header">Categories</h3>
 100     <div class="widget-content">
 101
 102     </div>
 103 </div>
 104
 105
 106
 107
 108     <div class="widget-archive-monthly widget-archive widget">
 109     <h3 class="widget-header">Monthly <a href="http://defaria.com/blogs/MAPS/archives.html">Archives</a></h3>
 110     <div class="widget-content">
 111         <ul>
 112
 113             <li><a href="http://defaria.com/blogs/MAPS/archives/2007/07/">July 2007 (1)</a></li>
 114
 115
 116
 117             <li><a href="http://defaria.com/blogs/MAPS/archives/2006/04/">April 2006 (1)</a></li>
 118
 119
 120
 121             <li><a href="http://defaria.com/blogs/MAPS/archives/2005/11/">November 2005 (2)</a></li>
 122
 123
 124
 125             <li><a href="http://defaria.com/blogs/MAPS/archives/2004/03/">March 2004 (1)</a></li>
 126
 127
 128
 129             <li><a href="http://defaria.com/blogs/MAPS/archives/2004/02/">February 2004 (3)</a></li>
 130
 131
 132
 133             <li><a href="http://defaria.com/blogs/MAPS/archives/2003/11/">November 2003 (3)</a></li>
 134
 135
 136
 137             <li><a href="http://defaria.com/blogs/MAPS/archives/2003/10/">October 2003 (9)</a></li>
 138
 139         </ul>
 140     </div>
 141 </div>
 142
 143
 144
 145
 146
 147 <div class="widget-pages widget">
 148     <h3 class="widget-header">Pages</h3>
 149     <div class="widget-content">
 150         <ul>
 151
 152
 153         </ul>
 154     </div>
 155 </div>
 156
 157 <div class="widget-syndication widget">
 158     <div class="widget-content">
 159         <ul>
 160             <li><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/MAPS/atom.xml">Subscribe to this blog's feed</a></li>
 161
 162         </ul>
 163     </div>
 164 </div>
 165 <div class="widget-powered widget">
 166     <div class="widget-content">
 167         <a href="http://www.movabletype.com/"><img src="http://defaria.com/mt/mt-static/images/bug-pbmt-white.png" alt="Powered by Movable Type 5.2.3" width="120" height="75" /></a>
 168     </div>
 169 </div>
 170
 171
 172
 173     </div>
 174 </div>
 175
 176
 177
 178
 179 <div id="gamma">
 180     <div id="gamma-inner">
 181     <div class="widget-search widget">
 182     <h3 class="widget-header">Search</h3>
 183     <div class="widget-content">
 184         <form method="get" action="http://defaria.com/mt/mt-search.cgi">
 185             <input type="text" id="search" class="ti" name="search" value="" />
 186
 187             <input type="hidden" name="IncludeBlogs" value="3" />
 188
 189             <input type="hidden" name="limit" value="20" />
 190             <input type="submit" accesskey="4" value="Search" />
 191         </form>
 192     </div>
 193 </div>
 194
 195 <div class="widget-about-this-page widget">
 196     <h3 class="widget-header">
 197
 198         About this Entry
 199
 200
 201     </h3>
 202     <div class="widget-content">
 203
 204
 205         <p class="first">This page contains a single entry by  published on <em>July 13, 2007  5:26 PM</em>.</p>
 206
 207         <p><a href="http://defaria.com/blogs/MAPS/archives/2006/04/no-more-defaria.html">No more &lt;anything&gt;@defaria.com</a> was the previous entry in this blog.</p>
 208
 209
 210
 211
 212
 213
 214
 215         <p>Find recent content on the <a href="http://defaria.com/blogs/MAPS/">main index</a> or look in the <a href="http://defaria.com/blogs/MAPS/archives.html">archives</a> to find all content.</p>
 216
 217     </div>
 218 </div>
 219
 220
 221     </div>
 222 </div>
 223
 224
 225
 226
 227                 </div>
 228             </div>
 229
 230
 231             <div id="footer">
 232     <div id="footer-inner">
 233         <div id="footer-content">
 234             <div class="widget-powered widget">
 235                 <div class="widget-content">
 236                     Powered by <a href="http://www.movabletype.org/">Movable Type</a>
 237                 </div>
 238             </div>
 239
 240         </div>
 241     </div>
 242 </div>
 243
 244
 245
 246         </div>
 247     </div>
 248 </body>
 249 </html>