[rt-users] too many Apache-Session queries at the end of every page

[Roy El-Hames]

Hi;
(apache2,mod_perl2,mysql5,rt-3.6,DBIx::SearchBuilder v1.42) ..
tailing mysqld.sql I noticed there are many SELECT GET_LOCK,SELECT 
RELEASE_LOCK executed at the end of every page .. the below snippet is 
only half the queries RT done after displaying the 
configuration/tools/systemconfiguration page ..
Is this right?? and is there a way to trim them a bit??
Regards;
Roy
541 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   545 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   545 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   542 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   542 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   545 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   545 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   542 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   545 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   542 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   542 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   544 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   544 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
060726  9:19:18     540 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   540 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   544 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   544 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   540 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   544 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   540 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   540 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   539 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   543 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   543 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   539 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   539 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   539 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   543 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   539 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   543 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   543 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   541 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   542 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   542 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   541 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   542 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   542 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   541 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   542 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   541 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   541 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   545 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   540 Query       SELECT  * FROM Users WHERE Name = 
'RT_System'
                   540 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   545 Query       SELECT  * FROM Users WHERE Name = 
'Nobody'
                   545 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   545 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   540 Query       SELECT 
GET_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a', 3600)
                   545 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')
                   540 Query       SELECT a_session FROM sessions WHERE 
id = '169c3aafceb7412cf7dfa7c1f4c4ae4a'
                   540 Query       SELECT 
RELEASE_LOCK('Apache-Session-169c3aafceb7412cf7dfa7c1f4c4ae4a')

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html