perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Perrin Harkins <per...@elem.com>
Subject Re: Apache::Session::MySQL lock troubles
Date Thu, 02 Mar 2006 19:40:44 GMT
On Thu, 2006-03-02 at 14:10 -0500, Dan Axtell wrote:
> I've been using Apache::Session::MySQL for a while, but I've been trying to 
> lower the amount of database I/O in some applications that experience spikes 
> in server traffic.  So I came up with the idea of using Apache::Session::File 
> with the files on /dev/shm, with a cron job to clear up old or expired 
> sessions.  Preliminary benchmarks found this to be about 7-8 times faster 
> than MySQL.

Sure, it's local.  Using BerkeleyDB would also be faster than MySQL.
The downside of your approach is that it can't scale across a cluster of
machines, and has no on-disk backup.  If you only have one machine, it's
probably fine.

- Perrin


Mime
View raw message