JBoss+Apache+Oracle 9 DB网站成日死

我公司个网站行紧JBoss + Apache + Oracle 9 DB

最近成日死....vendor 话个原因系太多人去我地个website.. DB太旧set O左DB connection restrict to 500 connections. 因600以上成日死....所以咁set..

佢次次死我都要restart JBoss (i.e. kill all connections) .. 咁先无事..但过半个钟一个钟又系咁..
我用top command check CPU 无事个时30 - 1xx%.. 有时个时过1000%

Web Server config: Xeon 6-core with hyperthreating x 2 (应该total 最大2400%)
但DB Server config: Xeon 2-core with hyperthreating x 2 (DB server 有8个systems 驳住total 连埋website)

vendor 话有事个时应该系D search engine 扫个site.. 搅到太多db connection to DB... DB 又应付唔度.. D connection 即死晒系个JBoss web server 度.. 搅到web server keep 晒D DB request 排队系web server 另web server 死...

DB server upgrade 又要D时间..

我谂紧可以做D乜.. e.g. 限死D search engine (不知名)O既..唔可以search our website using robots.txt?

Thanks for helping in advance!

[ 本帖最后由 lksforu 於 2013-11-20 12:16 PM 编辑 ]

Post the website please.

sorry.. can't post the website.. since dun wanna disclose this info to customers

Then can you inject Google Analytics to the whole site?

Google bots 会系同一时间 create 600 connections 去个 web site? 我谂唔会啦。我有个 forum，个时我个 db connections 得 60。咁耐都未试过同一时间超过 60 connections。

我估个系统根本无 close connections。你试下就知。起个 testing，系 internal LAN。净系自已去睇，系Oracle 睇番个 connections 有几多，同几时先 close。

其实个website 系for whole asia.. 大品牌..应该好多人睇O既...所以connection 应该多..
我岩岩set robots.txt Crawl-delay =5 ..希望有帮助啦...
佢45mins 死一次..衣家30 mins 啦..好紧张...

其实JBoss 有D setting 系for timeout delay.. 但vendor 之前set 过... 个system 就crash.. 改番default 衣家...

唉...都系无用...照45mins 度死一度..谂紧将咁多个region O既main page.. 唔allow search-engine search.... 有无大大有高见呢?

系Apache 到 set caching , 将 dynamic & static content (image , html and js ,etc)

咁个时有无做 sizing ？

老实讲，我真系有怀疑，同一时间有 600 个 connections？有无睇过 visit log？

45 mins死一次？我真系觉得唔关 google bots 事。

if RAM is sufficient, make it 2000 max connections first ...

it probably your web pages' code not proper ...

似系program 咬死左 db session
睇睇connection pool 写法
Db Transaction 点处理先