[Tickets #10978] Re: Issue viewing sessions when using MySQL/PDO Driver

[bugs at horde.org]

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);