I have a joomla site witch that have mysql overload problems, i think that the article counter its bloking the main table making a high overload on the entire server.. when a few visits came and visit the server get frezzed by the mysql.. i need help on this..
i think the problem is on this part of the code
******************************************************
SELECT [login to view URL], [login to view URL], [login to view URL], a.title_alias, [login to view URL], a.checked_out, a.checked_out_time, [login to view URL],[login to view URL], a.created_by, a.created_by_alias,
CASE WHEN [login to view URL] =0
THEN [login to view URL]
ELSE [login to view URL]
END AS modified, a.modified_by, [login to view URL] AS modified_by_name,
CASE WHEN a.publish_up =0
THEN [login to view URL]
ELSE a.publish_up
END AS publish_up, a.publish_down, [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL],[login to view URL], [login to view URL], [login to view URL], [login to view URL], LENGTH( [login to view URL] ) AS readmore,
CASE WHEN [login to view URL] IS NOT NULL
THEN 0
ELSE [login to view URL]
END AS state, [login to view URL] AS category_title, [login to view URL] AS category_route, [login to view URL] AS category_access, [login to view URL] category_alias,
CASE WHEN a.created_by_alias > ' '
THEN a.created_by_alias
ELSE [login to view URL]
END AS author, [login to view URL] AS author_email, [login to view URL] AS contactid, [login to view URL] AS parent_title, [login to view URL] parent_id, [login to view URL] AS parent_route, [login to view URL] AS parent_alias, ROUND( v.rating_sum /v.rating_count, 0 ) AS rating, v.rating_count AS rating_count, [login to view URL],
CASE WHEN [login to view URL] IS NULL
THEN [login to view URL]
ELSE 0
END AS parents_published
FROM dtf2b_content AS a
LEFT JOIN dtf2b_content_frontpage AS fp ON fp.content_id = [login to view URL]
LEFT JOIN dtf2b_categories AS c ON [login to view URL] = [login to view URL]
LEFT JOIN dtf2b_users AS ua ON [login to view URL] = a.created_by
LEFT JOIN dtf2b_users AS uam ON [login to view URL] = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX( [login to view URL] ) AS id, [login to view URL]
FROM dtf2b_contact_details AS contact
WHERE [login to view URL] =1
GROUP BY contact.user_id, [login to view URL]
) AS contact ON contact.user_id = a.created_by
LEFT JOIN dtf2b_categories AS parent ON [login to view URL] = c.parent_id
LEFT JOIN dtf2b_content_rating AS v ON [login to view URL] = v.content_id
LEFT OUTER JOIN (
SELECT [login to view URL] AS id
FROM dtf2b_categories AS cat
JOIN dtf2b_categories AS parent ON [login to view URL]
BETWEEN [login to view URL]
AND [login to view URL]
WHERE [login to view URL] = 'com_content'
AND [login to view URL] !=1
GROUP BY [login to view URL]
) AS badcats ON [login to view URL] = [login to view URL]
*****************************************
Hello sir I have done this task a couple of times in my past projects. I'm very much interested in doing this task for you. Thank you for giving your precious time to review my bid and check PM for more details!
Dear Client, I have just finished up reading your post ..I have 6 Years in Joomla- 225 completed Projects - 140 Satisfied Client - 86 countries - 5 Star ratings on Freelancer/Elance. Still going strong, please check your Inbox for my message - Regards, Derick Rethans
Hello. I'm MySQL database administrator specializing in performance optimization. Please check PMB where I propose few things that potentially can be done to improve speed of Your site