[nmglug] Production server question

[Andres Paglayan]

On Tue, 2009-03-31 at 20:02 -0600, Brendan wrote:

> 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?

it's 1 write 10 reads, without the log writing, which will make it like
12 writes 10 reads,

> 
> > 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.

right, and the logs can be rotated to another database every now and
then to keep the size smaller,
size wise, after a better calculation with indexes, it might grow about
1GB every 6 months,
(images aside which are kept on file system)
(not enough to catch up with Moore's law),
so starting with 8gb ram and duplicating the server every four years is
realistic,


> 
> -Brendan (Putting away the multi-terabyte-db advice)
> _______________________________________________
> nmglug mailing list
> nmglug at nmglug.org
> https://nmglug.org/mailman/listinfo/nmglug

-

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nmglug.org/pipermail/nmglug-nmglug.org/attachments/20090401/3b6b5bb5/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5505 bytes
Desc: not available
URL: <http://lists.nmglug.org/pipermail/nmglug-nmglug.org/attachments/20090401/3b6b5bb5/attachment.bin>