Fix cgi script Issue and SQL issue

[login to view URL] Can not access I I InMotion Systems Team to me 2 days agoDetails Hello Richard, Thank you for getting back with us. 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. 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: caretotr_abi[caretotr_abi] @ localhost [] # Query_time: 55.216536 Lock_time: 0.000083 Rows_sent: 21452 Rows_examined: 107260 SET timestamp=1391709318; SELECT [login to view URL], [login to view URL], [login to view URL], l.comment_count, l.last_comment_timestamp FROM node n INNER JOIN node_comment_statistics l ON [login to view URL] = [login to view URL] INNER JOIN term_node r ON [login to view URL] = [login to view URL] AND [login to view URL] = 1225 WHERE [login to view URL] = 1 ORDER BY [login to view URL] DESC, l.last_comment_timestamp DESC; # User@Host: caretotr_abi[caretotr_abi] @ localhost [] # Query_time: 8.787283 Lock_time: 0.000198 Rows_sent: 25 Rows_examined: 150189 SET timestamp=1391708949; SELECT [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] AS timestamp, [login to view URL] AS comment_mode, l.last_comment_timestamp, IF(l.last_comment_uid != 0, [login to view URL], l.last_comment_name) AS last_ comment_name, l.last_comment_uid, l.comment_count AS num_comments, [login to view URL] AS forum_tid FROM node_comment_statistics l INNER JOIN node n ON [login to view URL] = [login to view URL] INNER JOIN users cu ON l.last_comment_uid = [login to view URL] INN ER JOIN term_node r ON [login to view URL] = [login to view URL] INNER JOIN users u ON [login to view URL] = [login to view URL] INNER JOIN forum f ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 AND [login to view URL] = 1225 ORDER BY [login to view URL] DESC, l.last_comment_timestamp DESC, [login to view URL] ted DESC LIMIT 0, 25; In this case, it appears that there has been a large amount of comment spam on [login to view URL], and we strongly recommend cleaning your comments / registered users. 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 Please let us know if you have any further questions; we are more than happy to help. Best Regards, How am I doing? Please feel free to email my manager at: Thanks for using the help desk. If you have any further difficulties, or if you are required to respond to this request, please log in to the help desk. _______________________________________________ Thank you, GMAIL to Chris 2 days agoDetails Sent f Date: February 6, 2014 at 2:33:21 PM EST