[MTOS-dev] Performance

[Alvar Freude]

Hi,

(late answer, sorry)

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

> The database server is remote, 100mbps full duplex network.  Network
> latency is in the sub-microsecond range.  OS is FreeBSD 6.3 on all
> systems.

hmmm, if your network latency is in the sub-microsecond range, your 
network would be slower then my loopback interface ;-)

You should look at the ping time; on my FreeBSD servers it is in the rage 
of 0.5 to 0.8 Milliseconds on the local network and TCP is much slower 
and there are at least two TCP/IP packets: Query and response.
Movable Type has about thousand of simple/small queries per page, so the 
network overhead take some seconds per page.


> I have the SQL server installed on the mail server because of the 1.2
> million rows of spam tokens for SpamAssassin stored in the database.

Perhaps you should setup two database servers. You may setup an extra 
jail for them and can simply copy this to the other machine.


> The SQL disk is on a 6 x 10k Cheetah Raid 0 array connected to an Ultra
> 160 controller.

RAID 0? With 6 disks? Adventurous! ;-)

Since everything is cached in the RAM, the speed of the disks shouldn't 
really matter.


> This particlar blog consumed just over 15 meg of space in the database.
> I've got over 100 megs of Key Buffer with 20 megs each for Sort Buffer
> and Query Cache.  I think that's plenty considering that the blogs and
> anti-spam are the biggest SQL users.

yes, that sounds enough!

It would be interesting how PostgreSQL performs in your setup; MT makes 
some nonsense with PgSQL, but with 8.3 the thousands of read only 
transactions are not as hard as with older versions.


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/20080308/0e842acd/attachment.bin