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