CPU Usage marudufu

[bhanuprasad1981]

i kununuliwa vbet jana yenyewe na i kuona MySQL matumizi imeongezeka sana na matumizi ya CPU imekuwa mara mbili kwa kongamano wangu, ni kwa nini jinsi gani kudhibiti i?

[vBET]

vBET ni kufanya kitu kwa kurasa ya kawaida. Kizazi ya kawaida ya jukwaa yako hakuwa iliyopita.

Bila shaka umefanya kwa neno inapatikana jukwaa wako katika lugha zingine na hii si kuchukuliwa kutoka mahali pa - kutafsiriwa kurasa mahitaji ya rasilimali za nyongeza, lakini si wengi kama kuelezea. Tafadhali konde jinsi iliyopita trafiki kwa jukwaa yako - kama ghafla wewe kuzalisha kurasa zaidi ni jambo la kawaida kwamba CPU zaidi na maswali zaidi zinahitajika kwa hili. CPU hivyo kidogo zaidi kwa kweli inahitajika wakati wa kufanya mambo ya ziada, lakini kidogo tu na matumizi makubwa ya mafanikio ni kuhusiana na trafiki kubwa.

Kipaumbele katika data mwanzo kwa ajili ya tafsiri ni cached. Hii ina maana kuwa vizazi vijavyo ya ukurasa cached itakuwa kwa kasi zaidi (pia maswali chini ya mapenzi kuwa, tangu tafsiri kwanza ni kuangalia katika cache, basi ni kuchukuliwa kutoka Google, lakini wakati mwingine ni kuchukuliwa kutoka cache kwa tafsiri nyingine kuhusiana).

Jinsi gani unaweza salama CPU na maswali:

1. Hakikisha unatumia version mwisho. Tulikuwa na mdudu mdogo katika 3.2.1 ambayo kwa kweli inaweza kuboresha matumizi ya CPU hata kwa kurasa si kutafsiriwa (tayari kusahihishwa katika 3.2.2). Hivyo kama wewe ni kutumia 3.2.1 ni kweli kosa yetu - tafadhali update kwa 3.2.2
2. Unaweza Disable tafsiri zingine katika kuomba - wakati cache watashibishwa unaweza kuongeza ndio mpya mara kwa mara.
3. Tafadhali angalia una kuweka kutumia maswali na Serie - italeta maswali mengi chini ya database kwa data cached.
4. Disable tafsiri ya Google ramani kama sio kutumika
5. Kwa ajili ya baadaye itakuwa ni muhimu kwa wewe kuwa na sahihi Cache TTL. Kubwa ni bora, lakini si zaidi ya siku 15 kuwa wa haki na TOS Google
6. Pia kama una jukwaa kubwa kweli unahitaji mabadiliko cache yako clearing mkakati - maelezo katika maelezo parameter
7. Kwa ajili ya matumizi bora ya utendaji "Daima uaminifu user" Mkakati
8. Disable chaguo "usernames Je, si kutafsiri"
9. Block robots kwa kurasa si muhimu - kama kurasa wanachama, kalenda na kadhalika. Robots ni uwezo wa kutembelea kila kona ya jukwaa yako, lakini zaidi jukwaa haina haja ya kuwa mwanachama kurasa indexed, lakini bado itachukua jukwaa rasilimali zako ili kutafsiri kurasa hizo. Hivyo kuzuia robots kwa kurasa zote si sahihi katika tafsiri zote. Hapa chini utapata mfano robots.txt kwa kuwa - hii ni sehemu ya robots.txt kutumiwa na jukwaa hili (kumbuka hiyo ni URL ni iliyopita na vBSEO, na jukwaa wetu anatumia subdirectory katika URL).

User-agent: *
sitemap: http://www.vbenterprisetranslator.com/forum/sitemap_index.xml.gz
Disallow: /forum/members/
Disallow: /forum/af/members/
Disallow: /forum/sq/members/
Disallow: /forum/ar/members/
Disallow: /forum/be/members/
Disallow: /forum/bg/members/
Disallow: /forum/ca/members/
Disallow: /forum/zh-CN/members/
Disallow: /forum/hr/members/
Disallow: /forum/cs/members/
Disallow: /forum/da/members/
Disallow: /forum/nl/members/
Disallow: /forum/en/members/
Disallow: /forum/et/members/
Disallow: /forum/tl/members/
Disallow: /forum/fi/members/
Disallow: /forum/fr/members/
Disallow: /forum/gl/members/
Disallow: /forum/de/members/
Disallow: /forum/el/members/
Disallow: /forum/iw/members/
Disallow: /forum/hi/members/
Disallow: /forum/hu/members/
Disallow: /forum/is/members/
Disallow: /forum/id/members/
Disallow: /forum/ga/members/
Disallow: /forum/it/members/
Disallow: /forum/ja/members/
Disallow: /forum/ko/members/
Disallow: /forum/lv/members/
Disallow: /forum/lt/members/
Disallow: /forum/mk/members/
Disallow: /forum/ms/members/
Disallow: /forum/mt/members/
Disallow: /forum/no/members/
Disallow: /forum/fa/members/
Disallow: /forum/pl/members/
Disallow: /forum/pt/members/
Disallow: /forum/ro/members/
Disallow: /forum/ru/members/
Disallow: /forum/sr/members/
Disallow: /forum/sk/members/
Disallow: /forum/sl/members/
Disallow: /forum/es/members/
Disallow: /forum/sw/members/
Disallow: /forum/sv/members/
Disallow: /forum/zh-TW/members/
Disallow: /forum/th/members/
Disallow: /forum/tr/members/
Disallow: /forum/uk/members/
Disallow: /forum/vi/members/
Disallow: /forum/cy/members/
Disallow: /forum/yi/members/
Disallow: /forum/calendar.php
Disallow: /forum/af/calendar.php
Disallow: /forum/sq/calendar.php
Disallow: /forum/ar/calendar.php
Disallow: /forum/be/calendar.php
Disallow: /forum/bg/calendar.php
Disallow: /forum/ca/calendar.php
Disallow: /forum/zh-CN/calendar.php
Disallow: /forum/hr/calendar.php
Disallow: /forum/cs/calendar.php
Disallow: /forum/da/calendar.php
Disallow: /forum/nl/calendar.php
Disallow: /forum/en/calendar.php
Disallow: /forum/et/calendar.php
Disallow: /forum/tl/calendar.php
Disallow: /forum/fi/calendar.php
Disallow: /forum/fr/calendar.php
Disallow: /forum/gl/calendar.php
Disallow: /forum/de/calendar.php
Disallow: /forum/el/calendar.php
Disallow: /forum/iw/calendar.php
Disallow: /forum/hi/calendar.php
Disallow: /forum/hu/calendar.php
Disallow: /forum/is/calendar.php
Disallow: /forum/id/calendar.php
Disallow: /forum/ga/calendar.php
Disallow: /forum/it/calendar.php
Disallow: /forum/ja/calendar.php
Disallow: /forum/ko/calendar.php
Disallow: /forum/lv/calendar.php
Disallow: /forum/lt/calendar.php
Disallow: /forum/mk/calendar.php
Disallow: /forum/ms/calendar.php
Disallow: /forum/mt/calendar.php
Disallow: /forum/no/calendar.php
Disallow: /forum/fa/calendar.php
Disallow: /forum/pl/calendar.php
Disallow: /forum/pt/calendar.php
Disallow: /forum/ro/calendar.php
Disallow: /forum/ru/calendar.php
Disallow: /forum/sr/calendar.php
Disallow: /forum/sk/calendar.php
Disallow: /forum/sl/calendar.php
Disallow: /forum/es/calendar.php
Disallow: /forum/sw/calendar.php
Disallow: /forum/sv/calendar.php
Disallow: /forum/zh-TW/calendar.php
Disallow: /forum/th/calendar.php
Disallow: /forum/tr/calendar.php
Disallow: /forum/uk/calendar.php
Disallow: /forum/vi/calendar.php
Disallow: /forum/cy/calendar.php
Disallow: /forum/yi/calendar.php
Disallow: /forum/search.php
Disallow: /forum/af/search.php
Disallow: /forum/sq/search.php
Disallow: /forum/ar/search.php
Disallow: /forum/be/search.php
Disallow: /forum/bg/search.php
Disallow: /forum/ca/search.php
Disallow: /forum/zh-CN/search.php
Disallow: /forum/hr/search.php
Disallow: /forum/cs/search.php
Disallow: /forum/da/search.php
Disallow: /forum/nl/search.php
Disallow: /forum/en/search.php
Disallow: /forum/et/search.php
Disallow: /forum/tl/search.php
Disallow: /forum/fi/search.php
Disallow: /forum/fr/search.php
Disallow: /forum/gl/search.php
Disallow: /forum/de/search.php
Disallow: /forum/el/search.php
Disallow: /forum/iw/search.php
Disallow: /forum/hi/search.php
Disallow: /forum/hu/search.php
Disallow: /forum/is/search.php
Disallow: /forum/id/search.php
Disallow: /forum/ga/search.php
Disallow: /forum/it/search.php
Disallow: /forum/ja/search.php
Disallow: /forum/ko/search.php
Disallow: /forum/lv/search.php
Disallow: /forum/lt/search.php
Disallow: /forum/mk/search.php
Disallow: /forum/ms/search.php
Disallow: /forum/mt/search.php
Disallow: /forum/no/search.php
Disallow: /forum/fa/search.php
Disallow: /forum/pl/search.php
Disallow: /forum/pt/search.php
Disallow: /forum/ro/search.php
Disallow: /forum/ru/search.php
Disallow: /forum/sr/search.php
Disallow: /forum/sk/search.php
Disallow: /forum/sl/search.php
Disallow: /forum/es/search.php
Disallow: /forum/sw/search.php
Disallow: /forum/sv/search.php
Disallow: /forum/zh-TW/search.php
Disallow: /forum/th/search.php
Disallow: /forum/tr/search.php
Disallow: /forum/uk/search.php
Disallow: /forum/vi/search.php
Disallow: /forum/cy/search.php
Disallow: /forum/yi/search.php

[bhanuprasad1981]

1. i am kutumia latest version
2. jinsi ya afya ya tafsiri zingine?
3. jinsi / ambapo i kuweka aina ya maswali
4. i wala kutumia ramani za google
5. cache ni kuweka kwa muda wa siku 15 tayari
6. cache deletion mazingira i matumizi ya "kawaida deletion"
7. i am tayari kutumia "Daima uaminifu user"
8. kwenye jukwaa mgeni wangu hawawezi kuona mwanachama ukurasa, kalenda nk i tayari walemavu yao juu ya maoni katika vikao vbseo

[vBET]

2. Katika orodha Bendera
3. Katika Ziada - kama hakuwa na alifanya mabadiliko basi una tua ipasavyo
6. Baada ya wiki 2 utaona haina ti inafaa kwenye jukwaa yako. Kama si kutumia moja nyingine.

[bhanuprasad1981]

ajabu MySQL makosa kamwe kuona kabla got karibu 30 ya haya katika kipindi cha masaa 24: -

Database kosa katika vBulletin 3.8.2:

Batili SQL:

CHAGUA thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
IF (maoni <= replycount, replycount 1, maoni) AS maoni, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF (displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid
KUTOKA thread AS thread
Kushoto JOIN AS user user ON (user.username = thread.lastposter)
WAPI si ISNULL (thread.threadid) NA thread.visible = '1 'NA thread.open = '10!
NA thread.forumid NOT
ORDER BY dateline DESC
Kikomo 0, 10;

Hitilafu MySQL: Kuna kosa katika SQL syntax yako; kuangalia mwongozo kwamba sambamba na MySQL server version yako kwa syntax haki ya kutumia karibu '8, 9,10,64,67,68,69,71,72,77, 78,79,80,83,84,88,89,91,92,93,94,95,97,98,99,100,102 'katika mstari wa 9
Idadi Error: 1064
Ombi Date: Jumanne Novemba 24, 2009 @ 08:18:03
Hitilafu Date: Jumanne Novemba 24, 2009 @ 08:18:03
Script: http://www.mysite.org/search.php
Referrer:
Anwani ya IP: xx.xx.xx.xx
Username: Unregistered
Classname: vB_Database_MySQLi
MySQL Version:

[vBET]

Hii ni sababu katika SQL yako: 142,,8

Si kuhusiana na vBET - vBET haina kurekebisha maswali yoyote zilizopo na matumizi ya meza cache 3 tu katika maswali yake mwenyewe.

[vBET]

Pia moja ladha zaidi kwa ajili ya utendaji - unaweza Disable chaguo "usernames Je, si kutafsiri".

Nami kuongeza kwa jibu kwanza.

[bhanuprasad1981]

damm hii ni haunting SQL makosa yangu, juu ya ukaguzi kidogo i found IP ni ya buibui baadhi russian, si zifuatazo robots.txt nad anaendelea juu ya kwenda kwa ajili ya serach.php wazo lolote kuhusu hili yandex **** buibui, jinsi i kuzuia jambo hili

[vBET]

damm hii ni haunting SQL makosa yangu, juu ya ukaguzi kidogo i found IP ni ya buibui baadhi russian, si zifuatazo robots.txt nad anaendelea juu ya kwenda kwa ajili ya serach.php wazo lolote kuhusu hili yandex **** buibui, jinsi i kuzuia jambo hili

Find up IP yake na kuzuia katika chaguzi Vb au firewall.