CPU Itilizasyon Oblije

[bhanuprasad1981]

mwen te achte vbet yè tèt li ak mwen wè gen MySQL l 'ogmante yon anpil epi li gen itilizasyon CPU ki te double pou fowòm m' yo, ki sa ki rezon ki fè Ki jan mwen ka kontwole?

[vBET]

vBET ap fè anyen pou paj nòmal. Nòmal jenerasyon an fowòm ou pa t 'chanje.

Natirèlman ou te fè nan pawòl Bondye a ki disponib fowòm ou an nan lòt lang yo epi sa a pa pran nan men okenn kote - tradui paj bezwen lòt resous anplis, men se pa jan anpil jan ou dekri. Tanpri frich ki jan trafik la chanje fowòm ou - si ou toudenkou jenere pi plis paj li se nòmal ki gen plis CPU ak queries plis egzije yo pou sa. Se konsa, se ti kras pi plis CPU nan kou nesesè lè ou ap fè bagay sa yo anplis, men se jis yon ti kras pwogrè l 'ak yon gwo ki gen rapò ak pi gwo trafik yo.

Tanpri note ke nan done yo kòmanse pou tradiksyon ki cached. Sa vle di ke pwochen jenerasyon nan paj cached yo pral pi vit (tou mwens queries yo ap fèt, depi se premye tradiksyon gade nan kachèt, Lè sa a, se pran nan Google, men se pwochen fwa yo pran nan kachèt ak tradiksyon lòt ki gen rapò).

Ki jan ou ka san danje CPU ak queries:

1. Asire ou ke ou yo ap itilize dènye vèsyon. Nou te gen ti kras ensèk nan 3.2.1 ki reyèlman kapab amelyore itilizasyon CPU menm pou pa tradui paj (deja korije nan 3.2.2). Se konsa, si w ap sèvi ak 3.2.1 li se reyèlman fòt nou yo - tanpri aktyalizasyon 3.2.2
2. Ou ka gen kèk enfim nan tradiksyon t'ap mande charite a - lè kachèt yo pral plen ou ka ajoute nouvo de tan zan tan.
3. Tanpri tcheke fè ou te mete lè l sèvi avèk queries pa Serie - sa a ap fè anpil mwens queries baz done pou done cached.
4. Enfim tradiksyon nan kat Google si se pa itilize
5. Pou pita li pral enpòtan pou ou pou w gen ki apwopriye tl Cache. Pi gwo se pi bon, men se pa plis ke 15 jou yo dwe jis ak Google TOS
6. Epitou si ou gen fowòm reyèlman yon gwo w ap bezwen chanje estrateji kachèt netwaye ou - bay detay nan deskripsyon paramèt
7. Pou pi byen sèvi ak pèfòmans "Toujou mete konfyans itilizatè" estrateji
8. Enfim opsyon "pa tradui usernames"
9. Blòk robo pou paj pa enpòtan - tankou manm paj, kalandriye ak sou sa. Robo yo kapab ale nan tout kwen nan fowòm ou a, men sitou forum pa bezwen paj manm dwe Catalogue, men yo toujou li pral pran resous fowòm ou a tradui sa yo ki paj. Se konsa, blòk robo pou tout paj ki nan tout tradiksyon pa enpòtan. Piba a, w ap jwenn robots.txt egzanp pou sa - sa a se yon pati nan robots.txt itilize pa sa a fowòm (note ke URL la yo chanje pa vBSEO, ak fowòm nou an sèvi ak repèrtwar nan 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. Se mwen menm lè l sèvi avèk dènye vèsyon
2. kòman yo enfim kèk tradiksyon?
3. ki jan / kote mwen mete queries kalite
4. mwen pa sèvi ak kat Google
5. kachèt se fikse pou 15 jou deja
6. anviwònman deletion kachèt mwen itilize a se "sipresyon nòmal"
7. Se mwen menm deja lè l sèvi avèk "Toutan itilizatè mete konfyans"
8. sou fowòm envite m 'pa ka al gade paj manm, kalandriye elatriye mwen deja enfim yo sou sijesyon nan vbseo fowòm

[vBET]

2. Nan meni Flags
3. Nan Misc - si ou pa t 'fè chanjman Lè sa a, ou genyen li mete kòmsadwa
6. Apre 2 semèn ou pral wè fè ti adapte fowòm ou. Si ou pa sèvi ak lòt yon sèl.

[bhanuprasad1981]

etranj erè MySQL pa janm wè anvan te gen prèske 30 nan sa yo nan 24 èdtan pase: -

Erè nan baz done vBulletin 3.8.2:

Valid SQL:

CHWAZI thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
SI OU SE YON (views <= replycount, replycount +1, views) AS views, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
SI OU SE YON (displaygroupid = 0, user.usergroupid, displaygroupid) AS displaygroupid
De fil la AS fil
A GOCH JOIN itilizatè AS itilizatè SOU (user.username = thread.lastposter)
KI KOTE PA ISNULL (thread.threadid) AK thread.visible = '1 'AK thread.open! = '10 Haitian Creole Edition'
AK thread.forumid PA
LÒD POU PA dateline DESC
0 LIMIT, 10;

MySQL Erè: Ou gen yon erè nan sentaks SQL ou; tcheke manyèl la ki koresponn ak vèsyon MySQL sèvè ou pou sentaks la dwa sèvi ak tou pre '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 'nan liy 9
Nimewo Erè: 1064
Dat li te mande sa a: Madi, Novanm 2009 @ 08:18:03 24th PM
Dat li te Erè: Madi, Novanm 2009 @ 08:18:03 24th PM
Script: http://www.mysite.org/search.php
Referan:
Adrès IP: xx.xx.xx.xx
Username: Unregistered
Classname: vB_Database_MySQLi
MySQL Version:

[vBET]

Sa a se rezon an nan SQL ou: 142,,8

Li pa ki an relasyon ak vBET - vBET pa modifye nenpòt queries ki deja egziste epi li sèvi avèk sèlman 3 tab kachèt nan queries pwòp li an.

[vBET]

Epitou yon sèl plis allusion pou pèfòmans - ou ka enfim opsyon "pa tradui usernames".

Mwen pral ajoute li nan reply a an premye.

[bhanuprasad1981]

dam sa a SQL erè yo frekante m ', sou verifikasyon ti kras mwen te jwenn IP ki dwe nan kèk Spider russian, li pa ap swiv robots.txt nad kenbe sou pral pou serach.php okenn lide sou sa yandèks **** Spider, Ki jan pou mwen blòk bagay sa a

[vBET]

dam sa a SQL erè yo frekante m ', sou verifikasyon ti kras mwen te jwenn IP ki dwe nan kèk Spider russian, li pa ap swiv robots.txt nad kenbe sou pral pou serach.php okenn lide sou sa yandèks **** Spider, Ki jan pou mwen blòk bagay sa a

Jwenn moute IP li yo epi li bloke li nan VB opsyon oswa sou firewall.