急，空间挂了，说超出mysql ，可是我不明白老外说啥

landyliao

DaveB [6:13:09 PM]: According to the notes, your account was causing performance issues due to excessive mysql usage. They needed to suspend it as soon as they could to prevent other issues. If you would like to modify your site so that it uses less mysql resources we can make cPanel access available to you.
liao [6:14:50 PM]: can u tell me which domain in my cpanel cause the rescult.. and then i will make it
DaveB [6:18:55 PM]: It was any page that uses the chinese4_liao database. I'm having cPanel access enabled for you right now.
liao [6:19:26 PM]: and how i can do it? move the domain which use this database out of hostmonster?
[6:20:48 PM]: thanks for your kindly help
DaveB [6:20:57 PM]: You may want to check into implementing a form of caching on the site so that the pages don't have to request the same information from the database over and over. If your site already implements caching you may need to move it to a dedicated or virtual private server.
liao [6:23:16 PM]: ok
DaveB [6:24:14 PM]: cPanel and FTP access is now enabled for you. Once you have updated your site you can request it be reviewed for reactivation.
liao [6:25:01 PM]: and i don't know why chinese4_liao database cause the result
DaveB [6:26:23 PM]: There is very many queries being sent to the database. You need to reduce how many queries are sent.
liao [6:29:08 PM]: i can't visit my domain rightnow..
DaveB [6:30:06 PM]: Your site is suspended until you make the changes to your site but you can access cPanel.
liao [6:32:41 PM]: sorry , but i don't know how to change or what to do to make it work, sorry my english is poor .. i don't know which databse excessive mysql usage, chinese4_liao is just a user name that to contral my database
DaveB [6:34:53 PM]: Ok, if it's just a user we suggest you create a separate user for all your databases instead of using the same user for all your databases.
liao [6:39:30 PM]: yes ,i just use chinese4_liao to contral all my databases.. and now i have create a new user ,chinese4_best4c , and next what i can do
DaveB [6:46:05 PM]: create a user for each database to use.
liao [6:52:10 PM]: and had create,then must i delete the user name chinese4_liao?
DaveB [6:53:16 PM]: You don't have to delete it. You can still use it for one of your databases. We just want you to reduce how many queries that particular user makes. Using separate users for each of your database will help that.
liao [6:55:52 PM]: ok ,and what must i do next..
[6:56:11 PM]: i had make the change


他是叫我每个数据库里弄一个用户名吧，我弄完了，接下来不知道怎么办了，后来又问了另外一个人，他给我来句
you're going to need to look into ways to reduce the mysql load on our server being created by your account

我就不知道啥意思了。晕死

一路同行

他说你过度的使用mysql，造成了账户超资源

landyliao

那咋整啊？
you're going to need to look into ways to reduce the mysql load on our server being created by your account
这是什么意思啊

[ 本帖最后由 landyliao 于 2009-1-14 05:18 PM 编辑 ]

一路同行

让你减少mysql的负载

landyliao

晕，怎么减少啊
删掉几个MYSQL数据库？ 转走几个网站？ 还是怎么弄啊

boro

转走几个网站是正解，你现在所有加起来访问量多大啊

landyliao

我没流量啊。晕死。那几个网站加起来也就几百。。吐血了。。估计是我伪静态弄的

一路同行

HM资源限制比较紧，不建议开启伪静态
你是什么站？可能是操作数据库比较频繁

landyliao

娱乐站啊。。我晕了，但是是在昨天半夜给我停的啊，那时候我也没动数据库啊，而且那时没什么人上网啊

一路同行

不一定就是昨晚，国内和美国是有时差的，现在还能登录cpanel面板吗？实在不行暂时关闭几个网站或者限制访问量，等资源占用降下来再说