[rt-users] Apache Session locks in mysql slow query log

Ram ram0502 at gmail.com
Wed Aug 20 12:24:04 EDT 2014


Hey folks,

Running rt-4.2.2, mysql 5.6.20 x64, centos 6 current my mysql slow_query
log shows many queries of the form:

> # Time: 140818  9:40:45
> # User at Host: rt_user[rt_user] @ localhost []  Id: 25407
> # Query_time: 2.002034  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
> SET timestamp=1408369255;
> SELECT GET_LOCK('Apache-Session-0761de9e80f5596ac2a5201158f795a8', 3600);


Sessions are handled by Apache File Session:

> Set($WebSessionClass, "Apache::Session::File");

Two seconds seems like an long time for this, what am I missing?

thanks
Ram
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140820/aac62f5d/attachment.htm>


More information about the rt-users mailing list