Joomla Templates Club 406,261 posts

[nedzad grebovic Friend nedzad grebovicJoin date: July 2014Posts: 325Downloads:12Uploads:118 Thanks: 83 Thanked: 2 times in 1 posts]

#191689

my site is down, and my hosting answer me this. what does this means folks?
DID HOSTING SHOW ME SHIT?

____________________________________
System administration has been tracking higher resource usage on the machine housing your account and has traced these issues to long running mysql queries related to your account. We may be forced to suspend or have already suspended your site in order to stabilize the server.

Most queries should complete in less than a second. Some of the queries related to your account take a a lot longer than this to complete and seem to be the source of some latency we are seeing in the server’s response.

Here are examples of such queries:

# User@Host: namenamedb:[namnamedb] @ localhost []
# Query_time: 32.104767 Lock_time: 0.000180 Rows_sent: 1 Rows_examined: 132161
use db_name;
SET timestamp=1382650155;
SELECT COUNT(*)
FROM xyzTv5_content AS a
LEFT JOIN xyzTv5_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN xyzTv5_categories AS c ON c.id = a.catid
LEFT JOIN xyzTv5_users AS ua ON ua.id = a.created_by
LEFT JOIN xyzTv5_users AS uam ON uam.id = a.modified_by
LEFT JOIN xyzTv5_categories as parent ON parent.id = c.parent_id
LEFT JOIN xyzTv5_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xyzTv5_categories AS cat JOIN xyzTv5_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = ‘com_content’ AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = ‘0000-00-00 00:00:00’ OR a.publish_up <= ‘2013-10-24 21:24:32’) AND (a.publish_down = ‘0000-00-00 00:00:00’ OR a.publish_down >= ‘2013-10-24 21:24:32’);

In order to maintain stability and responsiveness of our server, you will need to review your site to see what you can do to remedy this issue. For information on how to do this, please visit our URL here under MySQL optimization:

http://support.inmotionhosting.com/site_help/index.php

If your site is currently suspended, please contact us to lift the suspension. If you cannot remedy the situation, you may need to upgrade to a more appropriate platform. Feel free to contact us with any further questions.
_____________________

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#510341

This is mysql issue and its difficult to guess the issue and give solution to you with above information.

You can give me URL of your site or more detail information to check the problem.

[Author]

Posts