[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-10 19:22) 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.