<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.18.3">
</HEAD>
<BODY>
On Tue, 2009-03-31 at 20:02 -0600, Brendan wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
Andres Paglayan wrote:
> doesn't look like a trivial issue,
> probably the db won't grow bigger than a GB in couple of years,
> although the usage of the writes is relatively 1/10 compared with the
> writes,
Was that writes are 1/10th of reads or reads are 1/10th of writes?
</PRE>
</BLOCKQUOTE>
it's 1 write 10 reads, without the log writing, which will make it like 12 writes 10 reads,
<BLOCKQUOTE TYPE=CITE>
<PRE>
> every actions gets logged, what makes the writes heavy as well,
> I just got what seems to be a good mysql book with lots of performance
> tuning info,
> oh boy, I love learning,
The db's not even 1GB? Well, that's a lot different. Stuff the sucker
full of RAM, create indexes on your popular keys, use RAID1 and you'll
be hauling ass. If you have more RAM than the size of your DB
(including indexes) you're hardly ever going to have a drive read
because all that data will be cached. If you're getting backlogged on
writes you can add a separate RAID1 device for the log data. If you
still have more IO than disk bandwidth move up to RAID 10. That's
unlikely though since your average drive these days can move in excess
of 100MB/s.
</PRE>
</BLOCKQUOTE>
right, and the logs can be rotated to another database every now and then to keep the size smaller,<BR>
size wise, after a better calculation with indexes, it might grow about 1GB every 6 months,<BR>
(images aside which are kept on file system)<BR>
(not enough to catch up with Moore's law),<BR>
so starting with 8gb ram and duplicating the server every four years is realistic,<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
<PRE>
-Brendan (Putting away the multi-terabyte-db advice)
_______________________________________________
nmglug mailing list
<A HREF="mailto:nmglug@nmglug.org">nmglug@nmglug.org</A>
<A HREF="https://nmglug.org/mailman/listinfo/nmglug">https://nmglug.org/mailman/listinfo/nmglug</A>
</PRE>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-
</TD>
</TR>
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>