[TYPO3-english] Hunging select from fe_sessions and fe_users
Vahan Amirbekyan
vamirbekyan at dgfoundation.org
Thu Mar 26 02:14:41 CET 2009
guys,
I am seeing tons of queries like this one in the show process:
SELECT * FROM fe_sessions,fe_users WHERE
fe_sessions.ses_id = 'e361c16a9f' AND fe_sessions.ses_name = 'fe_typo_user'
AND fe_sessions.ses_userid = fe_users.uid
AND (fe_sessions.ses_iplock='38.99'OR fe_sessions.ses_iplock='[DISABLED]')
AND fe_sessions.ses_hashlock=268278894 AND fe_users.disable=0 AND
fe_users.deleted=0 AND (fe_users.starttime<=1238029426) AND
(fe_users.endtime=0 OR fe_users.endtime>1238029426)
I added indexes on fe_sessions.ses_userid and fe_sessions.ses_hashlock
but it did not help much.
First, why suddenly I am seeing this selects?
What code are they from?
And should I use MyISAM or InnoDB for these fe_sessions and fe_users tables?
I am using InnoDB.
More information about the TYPO3-english
mailing list