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

Roy El-Hames rfh at pipex.net
Wed Jul 26 04:25:04 EDT 2006


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




More information about the rt-users mailing list