免费国外空间,国外免费空间,'s Archiver

小柒俱乐部 发表于 2011-1-13 20:11

000空间给我发邮件出现这个怎么回事? 你的账户执行一个缓慢的MySQL查询的疑问。

We have detected that your account executing a slow MySQL queries.

Username: a4675047
Domain: mcxiri.net23.net
Database: a4675047_338
MySQL User: a4675047_143
MySQL Query: show table status like \\\'pr_%\\\'

Slow MySQL queries are not allowed, because you share server resources with thousands of other users and your long lasting MySQL queries are slowering the server and other users are having MySQL performance and connectivity problems. Please optimize your MySQL queries as soon as possible.
Here are some good articles how to optimize MySQL queries: [url=http://www.google.com/search?q=optimize+mysql+queries][color=#0000ff]http://www.google.com/search?q=optimize+mysql+queries[/color][/url]

Good tips how you can optimize your scripts and make our servers run faster:
- Disable all parts of your website that allows anonymous posting, such as open forums, guestbooks. These days automated software fills all open areas of web with junk and content spam and increasing your database size.
- Disable visitors monitoring and tracking (each move of your visitor makes database query)
- Disable all unused modules
- Disable internal stats for your website - use [url=http://www.google.com/analytics/][color=#0000ff]http://www.google.com/analytics/[/color][/url] for example
- You may also logon to the phpMyAdmin and check which table has the most records. Then, if you think that this table does not contain any valuable information (such as logs, stats or cache), you can click on the `Empty` or `Truncate` icon to clean it.

We thank you for understanding,
[url=http://www.idc866.com/www.000webhost.com]www.000webhost.com[/url]

翻译后的:


[p=30, 2, left]我们都发现了,你的账户执行一个缓慢的MySQL的疑问。[/p]
[p=30, 2, left]a4675047用户名。[/p][p=30, 2, left]mcxiri.net23.net领域:[/p][p=30, 2, left]a4675047_338数据库:[/p][p=30, 2, left]a4675047_143 MySQL用户:[/p][p=30, 2, left]MySQL的查询:显示表状态像\ \ \ ' pr_ % \ \ \ '[/p]
[p=30, 2, left]缓慢的MySQL查询不被允许,因为你们有服务器资源与成千上万的其他用户和你的持久的MySQL查询被slowering服务器和其他用户MySQL性能和连通性有问题。请优化你的MySQL查询尽快。[/p][p=30, 2, left]以下是一些好的文章如何优化MySQL疑问:[url=http://www.google.com/search?q=optimize]http://www.google.com/search?q=optimize[/url] + MySQL +的疑问[/p]
[p=30, 2, left]好点子如何优化你的脚本,使我们的服务器跑得更快:[/p][p=30, 2, left]关闭所有部分——你的网站,允许匿名发布,如开放论坛,guestbooks。这些天的自动化软件充满开放区的网络用垃圾和内容垃圾邮件和增加你的数据库中备案的尺寸。[/p][p=30, 2, left]——使游客的监测和跟踪的(一个举动使访问者数据库查询)[/p][p=30, 2, left]-禁用所有未用模块[/p][p=30, 2, left]-禁用内部统计数据网站——使用[url=http://www.google.com/analytics/]http://www.google.com/analytics/[/url]为例[/p][p=30, 2, left]——你也可以登录到phpMyAdmin检查表的最记录。然后,如果你认为这张桌子不包含任何有价值的信息(如日志,状态或缓存),你可以点击“空”或“截断”图标做大扫除。[/p]
[p=30, 2, left]我们感谢您的理解,[/p][p=30, 2, left]www.000webhost.com[/p]

samlou 发表于 2011-1-13 21:32

000数据库不行,删除空间。

xiyo 发表于 2011-1-13 23:57

删除空间?这么严重?

idc886 发表于 2011-1-14 10:54

是的,如经常出现这问题,帐户会被挂起。

先了解一下,你的站用的什么程序,网站流量现在是多少IP、PV,数据库现在是多大??


还有,一定要记得优化,设置好缓存呀。

看这里去。
[url=http://www.idc866.com/thread-277-1-1.html]http://www.idc866.com/thread-277-1-1.html[/url]



[color=blue]特别注意:   用论坛的,别老是 登录论坛的后台去管理。  [/color]
[color=blue]论坛后台很占资源。就会引起缓慢的MySQL查询[/color]
[color=blue][/color]
[color=blue][/color]
[color=blue]二、备份和恢复数据库。别再用帝国了。。   引起缓慢的MySQL查询 帐户就会被封。[/color]
[color=blue][/color]
[color=blue]直接上000空间的 phpmyadmin 平台。下载和恢复数据库[/color]
[color=blue][/color]
[color=blue]或是直接使用程序自动的备份和恢复功能。[/color]

页: [1]


Powered by Discuz! Archiver 7.2  © 2001-2012 Comsenz Inc.