Użu CPU irdoppja

[bhanuprasad1981]

i mixtrija bieraħ vbet innifsu u i ara użu mysql żdied ħafna u l-użu CPU ġie rduppjat għal forum tiegħi, dak li huwa raġuni kif nista 'kontroll?

[vBET]

vBET qed tagħmel xejn għall-paġni normali. Ġenerazzjoni normali ta 'forum tiegħek ma tkunx inbidlet.

Naturalment inti magħmula lill-kelma disponibbli forum tiegħek fil-lingwi l-oħra u dan ma tittieħed minn imkien - paġni tradotti teħtieġ riżorsi addizzjonali, imma mhux kemm trid tiddeskrivi. Jekk jogħġbok mhux maħdum kif biddel il-traffiku għall-forum tiegħek - jekk f'daqqa waħda inti jiġġeneraw paġni ħafna aktar huwa normali li CPU aktar u aktar mistoqsijiet huma meħtieġa għal dan. CPU hekk ftit aktar tal-kors hija meħtieġa meta inti tagħmel affarijiet addizzjonali, iżda biss progress użu ftit u kbira hija relatata mat-traffiku akbar.

Jekk jogħġbok innota li fil-bidu tad-data għat-traduzzjoni huma Cached. Dan ifisser li l-ġenerazzjoni li jmiss tal-paġna Cached se jkun ferm aktar mgħaġġla (ukoll mistoqsijiet anqas se jsiru, peress li t-traduzzjoni ewwel ħares fil-cache, allura hija meħuda mill-Google, iżda l-ħin li jmiss hija meħuda mill-cache ma 'traduzzjonijiet oħra relatati).

Kif tista 'CPU sikur u mistoqsijiet:

1. Kun żgur li qed tuża l-aħħar verżjoni. Kellna bug ftit 3.2.1 li verament jistgħu jtejbu l-użu CPU anki għall-paġni mhux tradotti (diġà kkoreġuta fil-3.2.2). Mela jekk inti qed tuża 3.2.1 huwa verament tort tagħna - jekk jogħġbok aġġornament 3.2.2
2. Tista 'jiskonnettja xi traduzzjonijiet fil-tallaba fit-toroq - meta cache se jimtlew tista' żżid oħrajn ġodda minn żmien għal żmien.
3. Jekk jogħġbok iċċekkja għandek tuża sett mistoqsijiet minn serie - din se tagħmel mistoqsijiet ħafna inqas għad-database għal data Cached.
4. Itfi t-traduzzjoni ta 'Google mapep jekk ma jintużax
5. Għal aktar tard se jkun importanti għalik li jkollhom Cache TTL xierqa. Akbar huwa aħjar, iżda mhux aktar minn 15 ġurnata biex tkun ġusta ma 'TOS Google
6. Ukoll jekk ikollok forum verament kbir ser ikollok bżonn li jibdlu l-istrateġija tiegħek ikklerjar cache - id-dettalji fid-deskrizzjoni parametru
7. Għall-użu aħjar prestazzjoni "Dejjem fiduċja utent" strateġija
8. Itfi l-għażla "Ma tittraduċi usernames"
9. Blokk robots għal paġni mhux rilevanti - bħal paġni membri, kalendarju u l-bqija. Robots huma kapaċi li jżuru kull rokna ta 'forum tiegħek, imma l-aktar forum ma bżonn paġni membru jkun b'indiċi, iżda xorta se jieħdu riżorsi forum tiegħek biex tittraduċi dawk il-paġni. Allura blokk robots għal paġni kollha mhux rilevanti fil-traduzzjonijiet. Hawn taħt għandek issib eżempju robots.txt għal dak - dan huwa parti mill robots.txt tintuża minn dan il-forum (innota li ikteb huma mibdula mill vBSEO, u l-forum tagħna użi subdirectory fil 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 jużaw aħħar verżjoni
2. kif jiskonnettja xi traduzzjonijiet?
3. kif / fejn i stabbilit mistoqsijiet tip
4. i ma jużawx google mapep
5. cache huwa stabbilit għal 15-il jum diġà
6. tħassir settings cache i użu huwa "tħassir normali"
7. i am diġà jużaw "utent fiduċja Dejjem"
8. fuq mistieden forum tiegħi ma tistax ara l-paġna membru, eċċ kalendarja i diġà b'diżabilità minnhom fuq is-suġġeriment fil-fora vbseo

[vBET]

2. Fil Bnadar menu
3. Fil Misc - jekk inti ma għamel bidliet allura ikollok sett xieraq
6. Wara 2 ġimgħat int ser tara ma ti joqgħod għall-forum tiegħek. Jekk jużax wieħed ieħor.

[bhanuprasad1981]

żbalji stramba mysql qatt ma raw qabel ltqajna kważi 30 ta 'dawn fl-aħħar 24 siegħa: -

Żball database vBulletin 3.8.2:

Invalid SQL:

TAGĦŻEL thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
IF (fehmiet <= replycount, replycount 1, żjariet) KIF fehmiet, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF (displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid
MILL-ħajt KIF ħajt
XELLUG Jissieħbu utent bħala utent FUQ (user.username = thread.lastposter)
FEJN MA ISNULL (thread.threadid) U thread.visible = '1 'U thread.open! = '10'
U thread.forumid MHUX
ORDNI MILL dateline desc
LIMITU 0, 10;

Żball MySQL: Inti għandek żball fil-sintassi SQL tiegħek; jiċċekkja l-manwal li jikkorrispondi għall-verżjoni tiegħek MySQL server għall-sintassi dritt għall-użu qrib '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 "fil-linja 9
Numru żball: 1064
Data talba: it-Tlieta 24 Novembru, 2009 @ 08:18:03
Data żball: IT-TLIETA 24 Novembru, 2009 @ 08:18:03
Script: http://www.mysite.org/search.php
Referrer:
Indirizz IP: xx.xx.xx.xx
Username: Unregistered
Classname: vB_Database_MySQLi
MySQL Verżjoni:

[vBET]

Din hija r-raġuni fil SQL tiegħek: 142,,8

Ma huwa relatat ma 'vBET - vBET ma timmodifika xi mistoqsijiet eżistenti u l-użi tabelli cache biss 3 fil-mistoqsijiet huwa stess.

[vBET]

Wkoll wieħed ħjiel aktar għall-prestazzjoni - inti tista 'jiskonnettja l-għażla "Ma tittraduċi usernames".

I se jżidu mal-ewwel tweġiba.

[bhanuprasad1981]

Damm żbalji dan sql huma Haunting lili, mal-verifika ftit i misjub ip jappartjeni għal xi brimba Russu, mhuwiex ġej robots.txt nad jżomm għaddejjin għall serach.php ebda idea dwar dan yandex **** brimba, kif i blokk din il-ħaġa

[vBET]

Damm żbalji dan sql huma Haunting lili, mal-verifika ftit i misjub ip jappartjeni għal xi brimba Russu, mhuwiex ġej robots.txt nad jżomm għaddejjin għall serach.php ebda idea dwar dan yandex **** brimba, kif i blokk din il-ħaġa

Sib l-IP u l-blokk fil-għażliet vB jew fuq firewall.