帐号被停用两天，现在才发现。。

mefan

帐号被停用两天，现在才发现。。和客服讲，英语又不行，很难明白。。。大家帮忙看看。。。
mdocea [6:15:26 PM]: Thank you for choosing Live Chat. Please allow me a minute or two to review and respond to your question. If you have not already provided your Main Domain name please do so now along with any additional details you feel I should have. I take multiple chats at once. There will be a delay between my replies. Thank you for your patience. I will be right with you.
wujinhong [6:15:26 PM]: Why do my account be suspended?
[6:16:42 PM]: My Account is ******
The password is ******
[6:18:42 PM]:
Has been suspended for two days because other busy with work, I did not see the e-mail lead
mdocea [6:19:41 PM]: Here is the note that the system admin has placed on the account: "Causing alot of load with MySQL queries such as this: SELECT count(*) FROM `domain_articles` WHERE isdeleted = 0 I found around 10 of those at a time."
wujinhong [6:21:59 PM]:
I do not quite understand what you mean, I would like to know how kind resume my Account
mdocea [6:22:41 PM]: Do you have a web developer that builds your web-site ?
wujinhong [6:23:15 PM]: yes
mdocea [6:24:52 PM]: Please transmit that message to him or have him contact us.
[6:25:07 PM]: He will need to optimize your MySQL queries before we can re-activate your account.
wujinhong [6:26:32 PM]: Who is he? This account all the procedures are for a person I
mdocea [6:26:58 PM]: Are you familiar with optimizing MySQL queries ?
wujinhong [6:28:16 PM]: Not too familiar with, there is an easy way?
[6:31:01 PM]: is database the problem? By the deletion of certain forms meet the requirement?
mdocea [6:34:19 PM]: Yes the MySQL queries are the problem.
[6:34:28 PM]: By the deletion of certain forms meet the requirement? No.
[6:35:06 PM]: Please modify the queries: SELECT count(*) FROM `domain_articles` WHERE isdeleted = 0 so that they are not running 10 at a time and overloading the server.
[6:35:18 PM]: If you do not know how to do this you will have to have your web developer do that for you.
[6:35:26 PM]: In order to better focus on providing hosting support we do not provide any coding or development support.
[6:35:29 PM]: Did you have any other questions for me today ?

大漠孤狼

Causing alot of load with MySQL queries such as this: SELECT count(*) FROM `domain_articles` WHERE isdeleted = 0 I found around 10 of those at a time.

数据区查询太多了

mefan

能仔细说下吗？我该怎么恢复帐号，我的数据库内容还真多 。。。

大漠孤狼

原帖由 mefan 于 2008-2-15 05:17 PM 发表
能仔细说下吗？我该怎么恢复帐号，我的数据库内容还真多 。。。

这个只能是想办法降低数据库查询，或者优化程序，或者使用缓存之类的