求救空间商要求我优化mysql如何做啊

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

Username: a5027018
Domain: wangbwhz99.vacau.com
Database:
MySQL User:
MySQL Query: show table status like \\\'pre_%\\\'

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: http://www.google.com/search?q=optimize+mysql+queries

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 http://www.google.com/analytics/ 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.
求救空间商要求我优化mysql如何做啊

分享到: QQ空间 腾讯微博 腾讯朋友

管理员

Rank: 9 Rank: 9 Rank: 9

帖子: 8705
积分: 27266
金钱: 8451
在线时间: 1895 小时
注册时间: 2009-4-18
最后登录: 2023-10-10

2^#

idc886发表于 2012-11-29 17:21 | 只看该作者

好像没办法了。 000空间就是mysql 弱。。

如果是论坛的话，很容易挂的。

★ 11月开空间新规则，百度GG收录百贴：http://idc866.com/thread-15155-1-1.html
★ 本站转型：推荐免费空间，收集免费空间，免费空间测试，并提供原创申请教程。
★ 免备案空间，免费空间，免费国外空间，国外免费空间，免费美国空间
★ 我们是一群辛勤的小站站长，我们需要团结，我们需要共同进步！！！！
★ 达要求开空间，论坛发申请贴后，请加QQ：876812422 (一般在线、有Q必回)

其实，分享也是一种快乐！！有分享，才会有学习，才会有进步！快来分享你的快乐！

TOP