Thread

Is there any way to kill queries like this
this is from Show MySQL Processes on linux server

SELECT t.entry_id, t.weblog_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title,
SELECT t.entry_id FROM exp_weblog_titles AS t LEFT JOIN exp_weblogs ON t.weblog_id = exp_weblogs
SELECT t.tag_id, t.clicks, t.tag_name, t.total_entries, t.weblog_entries, t.gallery_entries,
SELECT exp_templates.template_name, exp_templates.template_id,
SELECT DISTINCT(t.entry_id) FROM exp_weblog_titles AS t LEFT JOIN exp_weblogs ON t.weblog_id = e
SELECT c.cat_name, c.cat_url_title, c.cat_id, c.cat_image, c.cat_description, c.parent_id, p.c

as they start to show up sometimes for some reason and make great load to mysql server
I allready read all abotout optimizing site. and make tweaks.

but every coupel days.. i get many queries like this that kill mysql server..

Any idea.

Are you using the tag module? Are you using any of the disable parameters with your exp:weblog:entries loops?

Yes using tag and disable..

I am afraid these look like legitimate, regular EE queries. Your page is being hit, and these queries are run as a result. With that in mind, there’s no way to “kill” them as such.