magmf
04-06-10, 13:00
伙計們,
我真的需要有vbet更加優化我的網站。
VBet是我獲得很多新的用戶我真的很喜歡這個工具,但使用過多的資源。
我的CPU負載之前VBET是波紋管2,現在是所有的時間超過 4
現在例如
8點 32分18秒最多11天,2:27,1個用戶,平均負載:7.45,8.24,8.26
附加一些門票從前後 vbet啟用我的網站
我想分享你,我躍升至70.000網頁索引的谷歌超過 500.000
我在Alexa的排名也躍升
副linux.org - 從 Alexa的網站信息(http://www.alexa.com/siteinfo/under-linux.org)
而且我每天都收到更多的訪問, 但我仍然需要一個更好的優化 vbet如何處理與查詢。
看一看我頂
top - 08:53:46 up 11 days, 2:49, 1 user, load average: 10.77, 9.81, 9.06
Tasks: 423 total, 5 running, 418 sleeping, 0 stopped, 0 zombie
Cpu(s): 15.7%us, 2.4%sy, 0.0%ni, 66.6%id, 9.8%wa, 0.1%hi, 5.4%si, 0.0%st
Mem: 12330536k total, 11619688k used, 710848k free, 24064k buffers
Swap: 995988k total, 994972k used, 1016k free, 2917568k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29384 mysql 20 0 5722m 2.5g 4552 S 99 20.9 3661:46 mysqld
你可以看到mysql的頂部,因為 vbet
MySQL的SHOW PROCESSLIST;
mysql> show processlist;
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
| Id | User | Host | db | Command | Time | State | Info |
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
| 3102552 | underlinux | localhost:49801 | underlinux | Query | 16 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102570 | underlinux | localhost:49843 | underlinux | Query | 12 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102597 | underlinux | localhost:49901 | underlinux | Query | 9 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102600 | underlinux | localhost:49907 | underlinux | Query | 9 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102617 | underlinux | localhost:49944 | underlinux | Query | 6 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102620 | underlinux | localhost:49953 | underlinux | Query | 6 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102632 | underlinux | localhost:49986 | underlinux | Query | 3 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102633 | underlinux | localhost:49988 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102636 | underlinux | localhost:49994 | underlinux | Sleep | 1 | | NULL |
| 3102639 | underlinux | localhost:50000 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102641 | underlinux | localhost:50005 | underlinux | Query | 0 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102648 | underlinux | localhost:50021 | underlinux | Sleep | 1 | | NULL |
| 3102649 | underlinux | localhost:50022 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102651 | root | localhost | NULL | Query | 0 | NULL | show processlist |
| 3102652 | underlinux | localhost:50027 | underlinux | Query | 0 | statistics | SELECT translated FROM vbvbenterprisetranslator_cache_medium_vi WHERE originaltext='Cadastrar+200+cl |
| 3102660 | underlinux | localhost:50044 | underlinux | Query | 0 | statistics | SELECT translated FROM vbvbenterprisetranslator_cache_medium_fa WHERE originaltext='BackTrack+4+%28F |
| 3102661 | underlinux | localhost:50047 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102663 | underlinux | localhost:50051 | underlinux | Sleep | 1 | | NULL |
| 3102664 | underlinux | localhost:50052 | underlinux | Query | 1 | end | UPDATE vbuser SET
profilevisits = profilevisits + 1
WHERE userid = 61484 |
| 3102666 | underlinux | localhost:50056 | underlinux | Query | 0 | update | REPLACE INTO vbdatastore
(title, data, unserialize)
VALUES
('cron', '1275652500', 0) |
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
20 rows in set (0.16 sec)
mysql>
mysql和CPU使用率前後 vbet
http://under-linux.org/wiki/images/1/14/Mysql-vbet.png
http://under-linux.org/wiki/images/f/f0/Vbetmysql2.png
http://under-linux.org/wiki/images/6/65/Vbet-cpuusage.png
我真的需要有vbet更加優化我的網站。
VBet是我獲得很多新的用戶我真的很喜歡這個工具,但使用過多的資源。
我的CPU負載之前VBET是波紋管2,現在是所有的時間超過 4
現在例如
8點 32分18秒最多11天,2:27,1個用戶,平均負載:7.45,8.24,8.26
附加一些門票從前後 vbet啟用我的網站
我想分享你,我躍升至70.000網頁索引的谷歌超過 500.000
我在Alexa的排名也躍升
副linux.org - 從 Alexa的網站信息(http://www.alexa.com/siteinfo/under-linux.org)
而且我每天都收到更多的訪問, 但我仍然需要一個更好的優化 vbet如何處理與查詢。
看一看我頂
top - 08:53:46 up 11 days, 2:49, 1 user, load average: 10.77, 9.81, 9.06
Tasks: 423 total, 5 running, 418 sleeping, 0 stopped, 0 zombie
Cpu(s): 15.7%us, 2.4%sy, 0.0%ni, 66.6%id, 9.8%wa, 0.1%hi, 5.4%si, 0.0%st
Mem: 12330536k total, 11619688k used, 710848k free, 24064k buffers
Swap: 995988k total, 994972k used, 1016k free, 2917568k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29384 mysql 20 0 5722m 2.5g 4552 S 99 20.9 3661:46 mysqld
你可以看到mysql的頂部,因為 vbet
MySQL的SHOW PROCESSLIST;
mysql> show processlist;
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
| Id | User | Host | db | Command | Time | State | Info |
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
| 3102552 | underlinux | localhost:49801 | underlinux | Query | 16 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102570 | underlinux | localhost:49843 | underlinux | Query | 12 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102597 | underlinux | localhost:49901 | underlinux | Query | 9 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102600 | underlinux | localhost:49907 | underlinux | Query | 9 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102617 | underlinux | localhost:49944 | underlinux | Query | 6 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102620 | underlinux | localhost:49953 | underlinux | Query | 6 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102632 | underlinux | localhost:49986 | underlinux | Query | 3 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102633 | underlinux | localhost:49988 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102636 | underlinux | localhost:49994 | underlinux | Sleep | 1 | | NULL |
| 3102639 | underlinux | localhost:50000 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102641 | underlinux | localhost:50005 | underlinux | Query | 0 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102648 | underlinux | localhost:50021 | underlinux | Sleep | 1 | | NULL |
| 3102649 | underlinux | localhost:50022 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102651 | root | localhost | NULL | Query | 0 | NULL | show processlist |
| 3102652 | underlinux | localhost:50027 | underlinux | Query | 0 | statistics | SELECT translated FROM vbvbenterprisetranslator_cache_medium_vi WHERE originaltext='Cadastrar+200+cl |
| 3102660 | underlinux | localhost:50044 | underlinux | Query | 0 | statistics | SELECT translated FROM vbvbenterprisetranslator_cache_medium_fa WHERE originaltext='BackTrack+4+%28F |
| 3102661 | underlinux | localhost:50047 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102663 | underlinux | localhost:50051 | underlinux | Sleep | 1 | | NULL |
| 3102664 | underlinux | localhost:50052 | underlinux | Query | 1 | end | UPDATE vbuser SET
profilevisits = profilevisits + 1
WHERE userid = 61484 |
| 3102666 | underlinux | localhost:50056 | underlinux | Query | 0 | update | REPLACE INTO vbdatastore
(title, data, unserialize)
VALUES
('cron', '1275652500', 0) |
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
20 rows in set (0.16 sec)
mysql>
mysql和CPU使用率前後 vbet
http://under-linux.org/wiki/images/1/14/Mysql-vbet.png
http://under-linux.org/wiki/images/f/f0/Vbetmysql2.png
http://under-linux.org/wiki/images/6/65/Vbet-cpuusage.png