[MTOS-dev] Performance

[Alvar Freude]

Hi,

-- Darin <derwood at naebunny.net> wrote:

> Woops.. Shoulda been sub-millisecond.. :)

:-)


> Don't know if I have enough memory to do that on the web server. I'll
> have to see if I can add memory to it.  With MySQL, I can set up a
> replication slave on the web server and have both DB's replicate to
> each other..

another option is to put the dynamic contents to the database server -- 
but this is often more complicated as running a second MySQL serve.

Or perhaps you can test it on a local testing machine with a copy of 
everything, not touching the running system ;-)

BTW, as you run FreeBD: In my setup everything runs in a FreeBSD jail, 
that's pretty cool: One apache2 jail as frontend and for static content, 
one PostgreSQL jail, one MySQL jail (for old stuff ;-) ), one jail for my 
mod_perl applications, one jail for MT etc. The frontend apache forwards 
the accesses to dynamic pages to the appropriate other jail.
I use ezjail -- <http://erdgeist.org/arts/software/ezjail/> -- for 
setting up the jails.


> Adventurous?  Maybe :)
> I take backups of important data in the DB hourly. So while its not
> mirrored, I'm willing to risk losing an hours worth of data.  Speed was
> my sole intent with the array.  Ease of recovery was secondary and I
> really didn't feel like losing speed or space to RAID5 checksums.

ah, OK, taking backups is a good idea.
I use cheap SATA drives and RAID1, and should take backup more often ...


> When it takes ~3000 lines of SQL to store a
> single comment, theres a serious problem.  1/10th of that would be too
> much even.

yes! :-)


Ciao
  Alvar


-- 
** Alvar C.H. Freude, http://alvar.a-blast.org/
** http://www.assoziations-blaster.de/
** http://www.wen-waehlen.de/
** http://odem.org/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 194 bytes
Desc: not available
Url : http://www.sixapart.com/pipermail/mtos-dev/attachments/20080309/39c38544/attachment.bin