AdvertCN - 广告中国

 找回密码
 立即注册

QQ登录

只需一步,快速开始

 谷歌+Bing+TT+MSN官方代理 
⚡️按条S5代理⚡️静态⚡️独享⚡️5G需要代理IP?⚡️Proxysites.ai⚡️指纹浏览器,就用AdsPower
Mediabuy⚡️玩家开户首选【鲁班跨境通-自助充值转账】FB/GG/TT❤️官方免费开户Affiliate 全媒体流量资源⚡️
Taboola/Outbrain /Bing⚡️一级代理开户投流-7*24h❤️人工在线【官方】❤️搜索套利买量投流开户独立站⚡️开户投放
FB BM不限额,短id账单户E.PN 虚拟卡DuoPlus专注打造跨境电商云手机BINOM TRACKER 60% OFF!
比Adplexity还好用的Spy工具ADPLEXITY + ADVERTCN7200W全球动态不重复住宅IP代理虚拟信用卡+独立站收款
全球虚拟卡, 支持U充值Facebook 批量上广告尤里改 - FB 稳定投放免费黑五教程(持续更新、欢迎交流)
FB 三不限源头 - 自助下户充值转款各种主页、账单户、BM户(优势)⚡️个人户,bm户不限额,账单户9Proxy ⚡️ $0.04/IP, 无限带宽
IPCola原生住宅IP⚡️$1.8/条双ISPGoogle、Bing官方总代  联盟流量开户fb耐用号0.01一个fb账号官方合作商
FB资源,账单户,分享户,国内一手FB企业户BM户账单户源头收FB代投工作室,收TrafficFactory账号IPWO全球住宅代理⚡️免费测试⚡️
FB海外三不限-户源多 费率低PTM全球虚拟卡—进来交个朋友!PTM虚拟卡⚡️费率透明⚡️额度随心FB虚拟卡⚡️消费越多返现越多
虚拟卡 - Pay2.House【找量】Blitzads独家单子广告位出租虚拟卡返佣1%,国内持牌机构
查看: 5342|回复: 9

[讨论] hostgator今天数据库出问题,大家有没有遇到?

[复制链接]

36

主题

372

广告币

851

积分

中级会员

Rank: 3Rank: 3

积分
851

社区QQ达人

发表于 2013-9-21 19:51:57 来自手机 | 显示全部楼层 |阅读模式
回复

使用道具 举报

36

主题

372

广告币

851

积分

中级会员

Rank: 3Rank: 3

积分
851

社区QQ达人

 楼主| 发表于 2013-9-21 20:05:12 来自手机 | 显示全部楼层
说我数据库占内存过大,怎么解决。我只有几百流量
回复 支持 反对

使用道具 举报

36

主题

372

广告币

851

积分

中级会员

Rank: 3Rank: 3

积分
851

社区QQ达人

 楼主| 发表于 2013-9-21 20:08:07 来自手机 | 显示全部楼层
Hello, 5 Z% L& f: m' i! }$ ~( T

$ m/ {* b& R& }  GThis message is to advise you of a temporary block placed on your database. The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved.
7 M& [) Z2 s) A* r& v3 V1 y% N9 b& Q
Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.
7 p$ U0 t/ j$ x+ Q( ?
! U% I- k; g8 v: xIf you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.
3 v, M3 e0 c! ?+ \! P1 A' F
/ ?3 J4 A& R' E' ?) d~~~ : B! G- ?. N  J2 C5 _; `5 L
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from ... and involving a large or complex query], (c) huge table copies/maintenance during peak hours.
1 Q, ~$ K& _4 m* X
; z. g: x; p& ~( v: `NOTE:, the following are just possible fixes or suggestions, and are not endorsed or supported by HostGator. They are included in the hope that they may apply to your situation, and/or help you reduce the amount of resources your SQL queries consume. As always, it's best to backup any data before making any changes or adjustments.   P+ L9 m1 R/ `. s2 W4 g) M

/ i7 `9 g; w& A  [* J% a; I5 `9 \First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table.. # q' O( M( s. |$ k# I
8 T7 E, c9 F1 q" u. f* W% U4 V
Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles (http://www.developer.com/db/article.php/3667831/Four-Ways-to-Optimize-Your-MySQL-Database.htm and http://www.databasejournal.com/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions. ! {/ ^5 ~+ M- @7 L# ]

2 n8 N; b8 {& \+ R: h- @5 aIf you reply back to this with your IP address (http://www.hostgator.com/ip.shtml) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.
回复 支持 反对

使用道具 举报

19

主题

290

广告币

532

积分

中级会员

Rank: 3Rank: 3

积分
532

社区QQ达人

发表于 2013-9-21 20:19:10 | 显示全部楼层
数据量有多少? 是自己写的程序还是用的WP ? CMS  ?
回复 支持 反对

使用道具 举报

36

主题

372

广告币

851

积分

中级会员

Rank: 3Rank: 3

积分
851

社区QQ达人

 楼主| 发表于 2013-9-21 20:30:12 来自手机 | 显示全部楼层
500文章。wp无采集。不能超啊
回复 支持 反对

使用道具 举报

1

主题

293

广告币

650

积分

中级会员

大叔

Rank: 3Rank: 3

积分
650

社区QQ达人

QQ
发表于 2013-9-21 21:35:59 | 显示全部楼层
昨天申请的1分主机被审查了
回到基础
回复 支持 反对

使用道具 举报

1630

主题

1万

广告币

2万

积分

管理员

宇宙无敌河马天神

Rank: 9Rank: 9Rank: 9

积分
26903

社区QQ达人

发表于 2013-9-21 22:36:51 | 显示全部楼层
可能被采集了造成的资源过度?
学会提问的艺术, 从小处入手, 忌大而空
AdvertCN电报群

我最喜欢用的工具
7200W全球动态不重复住宅IP代理
回复 支持 反对

使用道具 举报

51

主题

826

广告币

1785

积分

高级会员

Rank: 4

积分
1785
发表于 2013-9-21 23:22:50 | 显示全部楼层
主要是胸部过大,坠的
回复 支持 反对

使用道具 举报

87

主题

2927

广告币

3507

积分

版主

Rank: 7Rank: 7Rank: 7

积分
3507

社区QQ达人

发表于 2013-9-21 23:34:22 来自手机 | 显示全部楼层
我的站也出现间歇性的数据库错误
回复 支持 反对

使用道具 举报

36

主题

372

广告币

851

积分

中级会员

Rank: 3Rank: 3

积分
851

社区QQ达人

 楼主| 发表于 2013-9-22 16:22:05 | 显示全部楼层
换到其它的VPS,也弄挂了。Error establishing a database connection。应该是MYSQL数据库有问题
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关于我们|联系我们|DMCA|广告服务|小黑屋|手机版|Archiver|Github|网站地图|AdvertCN

GMT+8, 2025-5-10 04:24 , Processed in 0.051226 second(s), 14 queries , Gzip On, MemCache On.

Copyright © 2001-2023, AdvertCN

Proudly Operating in Hong Kong.

快速回复 返回顶部 返回列表