网站被停，BL客服说是mysql超限，怎办，我不懂数据库。

王红雷

网站被停，显示：
Please check back soon.
If you are the owner of this website, please log in for additional
information or contact us as soon as possible.


问BL 在线客服，客服说：
the site has been disabled due to your site scripts causing extremely high mySQL load on the server.
Please optimize queries and employ caching where possible. See MySQL slow query logs (/tmp/mysql_slow_queries on your account) for more information
Once you have located and corrected the issue, contact us again and let us know exactly what was done to fix the account.
If you require assistance in locating the problem, you may need to hire a database programmer for assistance

我该怎么办？

开心私塾

mysql脚本过度使用，登录你的cpanel面板下面在file manager里面(tmp/mysql_slow_queries 这个文件）看看里面的提示。

王红雷

非常感谢，
大清早还有热心人。

费了好大劲才找到这个目录
下面是很多日志文件。大致是这样的
file 20110225-12.log 168.64 KB 0644
file 20110225-13.log 146.16 KB 0644
file 20110225-14.log 133.16 KB 0644


打开其中一个，部分内容是：
# Fri Feb 25 19:45:14 2011
# Query_time: 8.729245  Lock_time: 0.007808 Rows_sent: 2  Rows_examined: 2
SHOW DATABASES

# Fri Feb 25 19:45:43 2011
# Query_time: 1.925064  Lock_time: 0.000110 Rows_sent: 2  Rows_examined: 2
SHOW DATABASES
FROM sdb_mall_goods as a  LEFT JOIN sdb_mall_offer_pcat as pc on a.catid = pc.catid  WHERE a.shop_iffb=1  AND a.offerid=1 AND a.brand_id = 408 AND (a.catid in (14)) AND a.ifobject != 3  AND pc.catiffb = 1 AND a.brand_id = 408 AND a.brand_id = 408 ORDER BY offer_ord DESC LIMIT 0,15

# Fri Feb 25 14:08:41 2011
# Query_time: 1.758243  Lock_time: 0.000181 Rows_sent: 34  Rows_examined: 11579
use chloebay_shop2003;
SELECT a.brand_id as brand_id,c.brand_name as brand_name FROM sdb_mall_goods as a
  INNER JOIN sdb_mall_brand as c ON a.brand_id=c.brand_id
  WHERE a.shop_iffb=1  AND a.offerid=1 AND catid in (14) and a.brand_id>0 group by brand_id

# Fri Feb 25 14:08:43 2011
# Query_time: 21.587775  Lock_time: 0.000143 Rows_sent: 15  Rows_examined: 35697
use chloebay_shop2003;
SELECT a.* FROM sdb_mall_goods as a  LEFT JOIN sdb_mall_offer_pcat as pc on a.catid = pc.catid  WHERE a.shop_iffb=1  AND a.offerid=1 AND (a.catid in (7,86,87,88)) AND a.ifobject != 3  AND pc.catiffb = 1 ORDER BY offer_ord DESC LIMIT 5505,15

# Fri Feb 25 14:09:02 2011
# Query_time: 1.108605  Lock_time: 0.000186 Rows_sent: 36  Rows_examined: 10142
use chloebay_shop2003;
SELECT a.brand_id as brand_id,c.brand_name as brand_name FROM sdb_mall_goods as a
  INNER JOIN sdb_mall_brand as c ON a.brand_id=c.brand_id
  WHERE a.shop_iffb=1  AND a.offerid=1 AND catid in (9) and a.brand_id>0 group by brand_id

# Fri Feb 25 14:09:18 2011
# Query_time: 1.440065  Lock_time: 0.000154 Rows_sent: 15  Rows_examined: 79947
SELECT a.* FROM sdb_mall_goods as a  LEFT JOIN sdb_mall_offer_pcat as pc on a.catid = pc.catid  WHERE a.shop_iffb=1  AND a.offerid=1 AND (a.catid in (6,16,18,19,20,21,22,157,158,159,161,160,134,135,136,137,138,140,141,142,143,164,145,146,147,148,149,150,151,152,162,163,165,166,167,186,191,192,193,200,201,202,203,204,205,206,207,208,209,211)) AND a.ifobject != 3  AND pc.catiffb = 1 ORDER BY offer_ord DESC LIMIT 11910,15

# Fri Feb 25 14:09:21 2011
# Query_time: 1.972144  Lock_time: 0.000205 Rows_sent: 48  Rows_examined: 73947
SELECT a.brand_id as brand_id,c.brand_name as brand_name FROM sdb_mall_goods as a
  INNER JOIN sdb_mall_brand as c ON a.brand_id=c.brand_id

备注，我网站是 shopex，昨晚没干啥，就是网站后台点击清理缓存更改后台汇率。

这是咋回事？

开心私塾

数据库查询过于频繁，你联系客服看他们要你如何操作吧。

王红雷

事情的解决让人想不到。


我再次联系BL在线客服，
问他该咋办
答复，你们做了哪些优化？你们应该请一位数据库工程师？
我说，我们不懂数据库，网站被关很急，不能立即找到工程师，能否给开2天，我网站搬走。
答复，不行，你删除网站后，我我们给你开开【这不是扯淡吗？】
我。。。。。。。。

答复，管理员决定给你一个机会，你是否保证不再犯同样错误
我 ：  可以把手按在圣经上发誓！



10秒后，网站正常。。。。

开心私塾

呵呵，赶紧给你的网站做一些优化吧，这样才能解决问题。

王红雷

shopex 系统，

不开源的，除了换模版，啥也不能干。。。。
这，只能，祈祷了。。。。。

或者立即搬家.