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