[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[no subject]
- <!--x-content-type: text/plain -->
- <!--x-date: Mon Feb 16 09:04:06 2004 -->
- <!--x-from-r13: wbanguna.tynff ng voo.tngrpu.rqh (Xbanguna Uynff) -->
- <!--x-message-id: 1076940126.25646.35.camel@ibb-250 -->
- <!--x-reference: Pine.LNX.4.44.0402160918440.31177-[email protected] --> "http://www.w3.org/TR/html4/loose.dtd">
- <!--x-subject: [ale] Any MySQL Experts around? -->
- <li><em>date</em>: Mon Feb 16 09:04:06 2004</li>
- <li><em>from</em>: jonathan.glass at ibb.gatech.edu (Jonathan Glass)</li>
- <li><em>in-reply-to</em>: <<a href="msg00531.html">[email protected]</a>></li>
- <li><em>references</em>: <<a href="msg00531.html">[email protected]</a>></li>
- <li><em>subject</em>: [ale] Any MySQL Experts around?</li>
Jonathan
On Mon, 2004-02-16 at 09:19, J.M. Taylor wrote:
> Jim,
>
> 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
> > <a rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale">http://www.ale.org/mailman/listinfo/ale</a>
> >
> >
--
Jonathan Glass
Systems Support Specialist II
Institute for Bioengineering & Bioscience
Georgia Institute of Technology
Email: jonathan.glass at ibb.gatech.edu
Office: 404-385-0127
Fax: 404-894-2291
</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<ul><li><strong>Follow-Ups</strong>:
<ul>
<li><strong><a name="00533" href="msg00533.html">[ale] Any MySQL Experts around?</a></strong>
<ul><li><em>From:</em> jtaylor at onlinea.com (J.M. Taylor)</li></ul></li>
</ul></li></ul>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00531" href="msg00531.html">[ale] Any MySQL Experts around?</a></strong>
<ul><li><em>From:</em> jtaylor at onlinea.com (J.M. Taylor)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00531.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00533.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00531.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00533.html">[ale] Any MySQL Experts around?</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00532"><strong>Date</strong></a></li>
<li><a href="threads.html#00532"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>
<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>