Apache::Session is occasionally hanging pages. If I stop the server, I find
the following in the error log:
http://waveright.homeip.net/~trwww/code/pmsi/4tp-bug.txt
using pre and post statment warn()s, I found that the line that causes the
hang is:
eval {
tie %{$session}, 'Apache::Se
looks like DBI stops talking to mysql
when this happens, is apache hanging?
or does it just crash on one page, and then continually crash on
subsequent pages?
a few ideas:
a
are you using the same dh / $dbh for session as the rest of
your site?
if so,
fyi , you can also see that in a regular mysql client
show processlist
this could also be a pure mysql problem. mysql is a fast db, but its
got some weird bugs.
i kept having issues with a collation matching problem on a table,
because I needed to change the column defaults from
From: "Jonathan" <[EMAIL PROTECTED]>
Subject: Re: Apache::Session::MySQL lock troubles
> looks like DBI stops talking to mysql
>
> when this happens, is apache hanging?
>
> or does it just crash on one page, and then continually crash on
> subsequent pages?
Y
how many connections do you get from a show processlist in mysql?
is it possible that some scoping issue had the connect occuring
during prefork, instead of postfork, and mysql is dying from apache
trying to do everything via 1 persistent connection?
"Jonathan" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> how many connections do you get from a show processlist in mysql?
It looks right, show processlist counts connections * processes, even during
a stress test.
> is it possible that some scoping issue had the connect occuri
.. just curious:
are you running on a Linux box with 2.6.x kernel ? If yes, then you
might have the trouble we had with apache AND mysql and pthreads.
Solution: just move /lib/tls to s.th. like /lib/tls.save and restart
mysql and apache -> solved.
If anyone likes, I can give more input.
ch
"Andreas Nolte" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> .. just curious:
>
> are you running on a Linux box with 2.6.x kernel ? If yes, then you
> might have the trouble we had with apache AND mysql and pthreads.
>
> Solution: just move /lib/tls to s.th. like /lib/tls.save an
hey,
I only saw the problem under SLES9 meaning 2.6.x kernels, but I think it
is a but in the glibc ( have to lookup the version... ), so you might
also see it with 2.4.x kernels.
It you look at your system with strace when it hangs, you will see the
following:
- there will be one process
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 ex
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
you could also try this:
store to /whatever/
read from memcached
failover to /whatever/
assuming you have the memory for it, it should handle spikes very well
12 matches
Mail list logo
