[Tickets #10978] Re: Issue viewing sessions when using MySQL/PDO Driver
bugs at horde.org
bugs at horde.org
Mon Feb 20 13:49:49 UTC 2012
DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
Ticket URL: http://bugs.horde.org/ticket/10978
------------------------------------------------------------------------------
Ticket | 10978
Updated By | it at wenn.com
Summary | Issue viewing sessions when using MySQL/PDO Driver
Queue | Horde Base
Version | 4.0.13
Type | Bug
State | Resolved
Priority | 1. Low
Milestone |
Patch |
Owners |
------------------------------------------------------------------------------
it at wenn.com (2012-02-20 13:49) wrote:
>>>> Without my patch the sessions page takes 9 seconds to open up, with
>>>> my patch it takes under 1 second to open up.
>>>
>>> It's still the wrong patch. You need to find out where it's spending
>>> the additional time.
>>
>> Ive narrowed down the problem.
>>
>> Horde/SessionHandler.php:177
>> It will hang on this call though to the DB read call but only if
>> userid is equal to the currently logged on userid. This was confimed
>> by putting a continue on a loop if id matched session_id;
>> So maybe it seems that you are still holding a row readlock open on
>> the session table of the user.
>
> This shouldn't happen. Can you track it further down into
> SessionHandler/Storage/Sql.php inside the read() method? Is it
> transactionStarted(), beginDbTransaction() or selectValue()?
It seems to be started in a different file to that you have listed.
SessionHandler/Storage/Stack.php
The read method in that file that i can get a clear time reading that
shows it locking up.
Ive worked out that there are two storage objects, memcached & sql.
The time seems to be sticking on the Memcached driver.
SessionHandler/Storage/Memcache.php # line 91 - $this->_memcache->lock($id);
More information about the bugs
mailing list