[pLog-svn] MMCache Statistics

[Oscar Renalias]

A 45% performance increase is not too much, but it's definitely better
than nothing. But I do agree that those 0.8s spent on db stuff are a
bit worrying... Hopefully your great work analyzing some of the sql
queries combined with Ben's work in the data caching area will boost
1.1's performance (in fact, the optimization of the sql queries could
even be integrated in the 1.0.2 branch -- I will look into that)

Oscar

On 7/2/05, Matt <matt at woodzy.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Additions to php.ini
> ^^^
> extension=mmcache.so
> 
> I decided on MMCache (http://turck-mmcache.sourceforge.net/) mainly
> because it has gotten rather good reviews within the community... It was
> pretty much a snap to install from source.
> 
> I installed MMCache from source following the basic instructions on the
> mmcache website.. it was rather straight forward...
> 
> ^^^
> $ phpize
> $ ./configure --with-gnu-ld --with-mmcache --enable-shared
> - --disable-static --with-php-config=/usr/bin/php4-config
> # make install
> ^^^
> 
> Then happily start editing the php.ini file...
> 
> ^^^
> ;;mmcache settings
> ;;optimized for plog 1.0.2
> 
> ;;found this was about what we needed
> ;;for all plog classes/cached templates
> mmcache.shm_size = 20
> mmcache.enable = 1
> mmcache.optimizer = 1
> 
> ;;check for modified php files...
> ;;could remove this for a production
> ;;server and save some disk access time
> mmcache.check_mtime = 1
> mmcache.debug = 0
> 
> ;;every file
> mmcache.filter =
> mmcache.shm_max = 0
> mmcache.shm_ttl = 0
> mmcache.shm_prune_period = 0
> ;;use only shared memory... screw disk
> mmcache.shm_only = 1
> ;;lose some memory... gain some cpu
> mmcache.compress = 0
> 
> ;;end mmcache settings
> ^^^
> 
> I got around a 45% gain when not caching... 65% gain when caching
> (smarty's templates are still executing crap... I also have my plugins
> out of the cached if statement in blogview).
> 
> ~1.1 seconds average execute with ~0.8sec mysql overhead... this is a
> strong indicator to me at least that there is alot of mysql optimization
> that needs to occur in the future.
> 
> Lag from smarty is nonexistant. ADODB average lag time ~.15seconds...
> Lag from pLog classes mainly
> 
> These performance gains are rather low compared to other php programs on
> the same server... for example my forums had almost an 110% gain in
> speed... it could be from all the files in pLog.
> 
> Your milage will probably vary.
> 
> Less time to type tonight :)...
> 
> - --
> Matt (matt\ at\ woodzy.com)       Public Key: woodzy.com/woodzy.gpg.asc
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (GNU/Linux)
> 
> iD8DBQFCxd1NU6nK5d/DeZURAtXzAKCCsdFytOTK3OANtOsqU6nFpHHDkQCgnI8z
> QRlzByYJMZyaxYzLPvawauw=
> =NWYf
> -----END PGP SIGNATURE-----
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.plogworld.net
> http://devel.plogworld.net/mailman/listinfo/plog-svn
>