[no subject]

Obviously, if he had said Oracle or DB2 (or even Informix) I would not 
have posted what I did.

MySQL cannot handle such things.

jenn

On Mon, 16 Feb 2004, Jim Popovitch wrote:

> On Sun, 2004-02-15 at 12:12, J.M. Taylor wrote:
> > I would strongly urge you *not* to store your log files in any relational 
> > database.  There's just no reason to do it...
> 
> I know of several Fortune 100 companies that do this.  The obvious reason 
> is for reporting purposes.  If I put all my syslog entries into a database, 
> that can handle them, then I can easily produce reports that show me 
> valuable data.  Imagine having 1000 servers and wanting to know the top 10 
> systems that had more than 2 root login failures per month.  Try doing that 
> with grep/sed/awk :)
> 
> Oracle and DB2 can scale to hundreds of millions of rows and still be
> easily queried.  The trick is to use partitioning and to know in advance
> how you will need your indexes setup.
> 
> -Jim P.
> 
> 
> 
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; 
&gt; 

-- 
Jenn Taylor
Systems Analyst, CIS
Armstrong Atlantic State University
912.921.5980
taylorje at mail.armstrong.edu


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00532" href="msg00532.html">[ale] Any MySQL Experts around?</a></strong>
<ul><li><em>From:</em> jonathan.glass at ibb.gatech.edu (Jonathan Glass)</li></ul></li>
<li><strong><a name="00544" href="msg00544.html">[ale] Any MySQL Experts around?</a></strong>
<ul><li><em>From:</em> jimpop at yahoo.com (Jim Popovitch)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00530" href="msg00530.html">[ale] Any MySQL Experts around?</a></strong>
<ul><li><em>From:</em> jimpop at yahoo.com (Jim Popovitch)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00530.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00532.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00530.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00532.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00531"><strong>Date</strong></a></li>
<li><a href="threads.html#00531"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>