[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