actually i have a dedicated server that has 12 cache memory ! and the problem is very clear , and wastes a lot of visitors ! and money !
my host is : Site-Ground company that told me the problem in slow MYSQL queries
my site domain is : http://www.yallashare.com
this what the host company told me and please need urgent help
Below is an excerpt of some of the slow queries generated by your websites:
SELECT a.referreid, SUM(a.points) AS sumpoints, u.username AS username, u.name AS name FROM jos_alpha_userpoints_details AS a, jos_alpha_userpoints AS aup, jos_users AS u WHERE aup.referreid=a.referreid AND aup.userid=u.id AND a.approved='1' AND a.status='1' AND aup.referreid!='AUPRR-HANI' GROUP BY a.referreid ORDER BY sumpoints DESC LIMIT 10
Executed 3 min ago for 3 sec on Database --> unknown.
SELECT a.referreid, SUM(a.points) AS sumpoints, u.username AS username, u.name AS name FROM jos_alpha_userpoints_details AS a, jos_alpha_userpoints AS aup, jos_users AS u WHERE aup.referreid=a.referreid AND aup.userid=u.id AND a.approved='1' AND a.status='1' AND aup.referreid!='AUPRR-HANI' GROUP BY a.referreid ORDER BY sumpoints DESC LIMIT 10
Executed 3 min ago for 3 sec on Database --> unknown.
SELECT a.referreid, SUM(a.points) AS sumpoints, u.username AS username, u.name AS name FROM jos_alpha_userpoints_details AS a, jos_alpha_userpoints AS aup, jos_users AS u WHERE aup.referreid=a.referreid AND aup.userid=u.id AND a.approved='1' AND a.status='1' AND aup.referreid!='AUPRR-HANI' GROUP BY a.referreid ORDER BY sumpoints DESC LIMIT 10
Executed 1 min ago for 6 sec on Database --> unknown.
SELECT a.referreid, SUM(a.points) AS sumpoints, u.username AS username, u.name AS name FROM jos_alpha_userpoints_details AS a, jos_alpha_userpoints AS aup, jos_users AS u WHERE aup.referreid=a.referreid AND aup.userid=u.id AND a.approved='1' AND a.status='1' AND aup.referreid!='AUPRR-HANI' GROUP BY a.referreid ORDER BY sumpoints DESC LIMIT 10
Executed 0 min ago for 4 sec on Database --> unknown.
SELECT a.referreid, SUM(a.points) AS sumpoints, u.username AS username, u.name AS name FROM jos_alpha_userpoints_details AS a, jos_alpha_userpoints AS aup, jos_users AS u WHERE aup.referreid=a.referreid AND aup.userid=u.id AND a.approved='1' AND a.status='1' AND aup.referreid!='AUPRR-HANI' GROUP BY a.referreid ORDER BY sumpoints DESC LIMIT 10
Executed 0 min ago for 4 sec on Database --> unknown.
SELECT a.referreid, SUM(a.points) AS sumpoints, u.username AS username, u.name AS name FROM jos_alpha_userpoints_details AS a, jos_alpha_userpoints AS aup, jos_users AS u WHERE aup.referreid=a.referreid AND aup.userid=u.id AND a.approved='1' AND a.status='1' AND aup.referreid!='AUPRR-HANI' GROUP BY a.referreid ORDER BY sumpoints DESC LIMIT 10
Executed 0 min ago for 6 sec on Database --> unknown.
SELECT a.referreid, SUM(a.points) AS sumpoints, u.username AS username, u.name AS name FROM jos_alpha_userpoints_details AS a, jos_alpha_userpoints AS aup, jos_users AS u WHERE aup.referreid=a.referreid AND aup.userid=u.id AND a.approved='1' AND a.status='1' AND aup.referreid!='AUPRR-HANI' GROUP BY a.referreid ORDER BY sumpoints DESC LIMIT 10
Please, note that slow queries are not part of the normal website operation and they are usually due to large or not properly designed MySQL databases or query logic.
