What are these queries doing?
Posted: Fri Apr 22, 2005 5:49 am
My site went down today and my host said it was becuase some up the queries were lasting upwards of 250 seconds without closing.
the top 5 queries that were taking ages were
Im not really sure what these queries are doing, especially the top two (copy to temp table!?!?). Can someone enlighten me?
Thanks
Mark
the top 5 queries that were taking ages were
Code: Select all
Kill 1 mbeech localhost.localdomain:47115 themgzr_co_uk_-_newforum Query 238 Copying to tmp table SELECT f . * , p . * , pt . * , t . * , u . *
FROM phpbb_topics AS t, phpbb_users AS u, phpbb_post
Kill 2 mbeech localhost.localdomain:47117 themgzr_co_uk_-_newforum Query 239 Copying to tmp table SELECT f . * , p . * , pt . * , t . * , u . *
FROM phpbb_topics AS t, phpbb_users AS u, phpbb_post
Kill 3 mbeech localhost.localdomain:47126 themgzr_co_uk_-_newforum Query 155 Locked SELECT aa.forum_id, u.user_id, u.username
FROM phpbb_auth_access aa, phpbb_user_group ug, phpbb_g
Kill 4 mbeech localhost.localdomain:47135 themgzr_co_uk_-_newforum Query 232 Locked UPDATE phpbb_users SET user_session_time =1114161993,
user_session_page =0,
user_lastvisit =1
Kill 5 mbeech localhost.localdomain:47140 themgzr_co_uk_-_newforum Query 228 Locked SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '26425b9ff7ee55b3f0fThanks
Mark